When I click on RUN, it is just considering the 1st line of condition which is of "30" and ignoring the rest. I'm clueless as I'm new to Alteryx
Can someone help me here?
IF [Days Pending for - PT]>30 THEN ">30 Days"
ELSEIF [Days Pending for - PT]>19 THEN "20-30 Days"
ELSEIF [Days Pending for - PT]>9 THEN "10-20 Days"
ELSEIF [Days Pending for - PT]>5 THEN "6-10 Days"
ELSEIF [Days Pending for - PT]<6 THEN "0-5 Days"
ELSE "NA"
ENDIF
Solved! Go to Solution.
Hey @Abhishekjoshua,
If statements apply the logic in the order you right them AKA they apply the first rule which works. I would write that statement like this:
IF [Days Pending for - PT]<6 THEN "0-5 Days"
ELSEIF [Days Pending for - PT]<11 THEN "6-10 Days"
ELSEIF [Days Pending for - PT]<21 THEN "10-20 Days"
ELSEIF [Days Pending for - PT]<31 THEN "20-30 Days"
ELSEIF [Days Pending for - PT]>30 THEN ">30 Days"
ELSE "NA"
ENDIF
The community has some quick and easy videos on formulas and the Formula Tool here https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Writing%20...
Any questions or issues please ask :)
HTH!
Ira