Formula issue when using 'not equal to'

Question

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

Carlyn · Accepted Answer

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