Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
16 replies
Subscribers
2 subscribers
Views
3917 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Reports
100749 - no subject - I am trying to create a simple report of
Keith
over 11 years ago
I am trying to create a simple report of tasks that are late. I have it created. I created a filter set for the task status so you can see completed, assigned and accepted statuses. I want to also have a choice of Active. I have tried and tried and tried to make this happen and everything I try is not working.
I even created a rule with: called activeTask with =if(ri!taskStatus="Active",1,
if(ri!taskStatus="Assigned",1,
if(ri!taskStatus="Accepted",1,0)))
When I put try : =rule!activeTask(task_status()) I get all 0s in the report and no 1s.
What am I doing wrong?
I tried the if expression without a rule and it would not produce desired result either.
I don't want to be negative - but - simple things like this cause people not to want to learn how to do reports on their own.
...
OriginalPostID-100749
Discussion posts and replies are publicly visible
Parents
0
Keith
over 11 years ago
Thank You for the tips - however - this did not work either. If I test the rule, I get the desired results. However the report is showing all 0s.
I changed the rule to be this.
=if(like(typename(typeof(ri!taskStatus)),"Active"),1,
if(like(typename(typeof(ri!taskStatus)),"Assigned"),1,
if(like(typename(typeof(ri!taskStatus)),"Accepted"),1,0)))
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Keith
over 11 years ago
Thank You for the tips - however - this did not work either. If I test the rule, I get the desired results. However the report is showing all 0s.
I changed the rule to be this.
=if(like(typename(typeof(ri!taskStatus)),"Active"),1,
if(like(typename(typeof(ri!taskStatus)),"Assigned"),1,
if(like(typename(typeof(ri!taskStatus)),"Accepted"),1,0)))
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data