Achieve IF Function

Question

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.

error.JPG

ShankerV · Accepted Answer

Hi @Diana_yahya

Please use the below

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

Many thanks

Shanker V

IraWatt · Accepted Answer

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 Answer

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