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
4 subscribers
Views
3155 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 10 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
jesse.triplett
Appian Employee
over 10 years ago
Testing just that if statement with a text input seems to work fine. You could try using the like() or exact functions instead of the "=" , I think I've ran into something similar in the past. Have you used typename(typeof(ri!taskStatus)) to be sure the input is a text?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
jesse.triplett
Appian Employee
over 10 years ago
Testing just that if statement with a text input seems to work fine. You could try using the like() or exact functions instead of the "=" , I think I've ran into something similar in the past. Have you used typename(typeof(ri!taskStatus)) to be sure the input is a text?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data