Achieve IF Function

[Diana_yahya]

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.

[ShankerV · Accepted solution]

Hi @Diana_yahya 

Please use the below

IF [Days Open]>=90 THEN "Y" ELSE "N" ENDIF

Many thanks

Shanker V

[IraWatt · Accepted solution]

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

[ShankerV · Accepted solution]

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

[Diana_yahya]

Thanks for pointing this. Very helpful.