Hello Team,
I have this challenging situation. I need to add the IF Forumal to my workflow.
If the Column Days Open is over 90 days Yes. or else No.
I have tailored the formula as well below but running it keeps giving errors as the attached
IF [Days Open]==>90 THEN "Y" ELSE "N" ENDIF
Any suggestion or help would be appreciated.
Solved! Go to Solution.
Hi @Diana_yahya
Please use the below
IF [Days Open]>=90 THEN "Y" ELSE "N" ENDIF
Many thanks
Shanker V
Hey @Diana_yahya,
Your getting that error from the ==> as it is not an operator in Alteryx. In Alteryx greater than or equal two is wrote as >=.
IF [Days Open]>=90 THEN "Y" ELSE "N" ENDIF
Hi @Diana_yahya
>= is the right symbol and hope that will resolve your issue.
If the issue still persists, check whether the incoming data set where you are comparing 90 is Int data type.
Many thanks
Shanker V
Thanks for pointing this. Very helpful.