Formula issue when using 'not equal to'

[Carlyn]

Hi

Seems like a ridiculous question but can anyone tell me why the 2nd formula below does not work in my workflow?

I have identified that it is the exclamation mark that appears to be the issue as when I remove that the formula works fine, but I am not aware of any other way to identify data that does not equal what I am looking for. I have included a screen shot to show how it appears in my Alteryx.

1. IF ([Category] = "Due To/Due From" and [ABS] >500000) THEN "Over" ELSE "Under" ENDIF

2. IF ([Category] != "Due To/Due From" and [ABS] >1000000) THEN "Over" ELSE "Under" ENDIF

[davidskaife]

Hi @Carlyn 

!= is the right syntax. The error is at the greater than point - what is the error message you're getting, what is the data type of ABS, and what data type are you setting the column as?

[Carlyn · Accepted solution]

Thanks for replying

Parse Error at char (138):Malformed if statement.

I did think it was relating to the > , but I coudn't understand why the formula works when I remove the ! and also all the columns are the same as the ones used in the 1st formula and that is working.

However, I just double checked the ABS data type and it was Vstring so I have updated it to Fixed Decimal and the formula is now working.

Thanks again