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.

...

Discussion posts and replies are publicly visible

Parents

0 jesse.triplett
Appian Employee
over 10 years ago

Sorry, I wasn't very clear. I meant try the like() function, and if that still doesn't work, double check that your input is being read as type text by having the expression just be typename(typeof(ri!taskStatus)) (no if statements at all, just checking that the output of this statement is the word "text" like expected.

if(like(ri!taskStatus,"Active"),1,
if(like(ri!taskStatus,"Assigned"),1,
if(like(ri!taskStatus,"Accepted"),1,0)))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 jesse.triplett
Appian Employee
over 10 years ago

Sorry, I wasn't very clear. I meant try the like() function, and if that still doesn't work, double check that your input is being read as type text by having the expression just be typename(typeof(ri!taskStatus)) (no if statements at all, just checking that the output of this statement is the word "text" like expected.

if(like(ri!taskStatus,"Active"),1,
if(like(ri!taskStatus,"Assigned"),1,
if(like(ri!taskStatus,"Accepted"),1,0)))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data