Formula error

[Lizbhernan]

Can someone tell me why my formula is not working 

IF NOT IsNull([ADJ Pension Override Amt]) AND [ADJ Pension Override Amt] <> 0 THEN [ADJ Pension Override Amt] ELSEIF NOT IsNull([ADJ Pension Override Rate]) AND [ADJ Pension Override Rate] <> 0 THEN [ADJ Hours] * [ADJ Pension Override Rate] ELSE [ADJ Hours] * [Pension Rate] ENDIF

I get an error stating that states "An expression cannot end with an operator" but not sure why. I have included an example of my WF.

I tried changing the data type and that didn't help. Any assistance would be highly appreciated.

TIA

[alexnajm]

"<>" does not work in Alteryx - try "!="

[alexnajm · Accepted solution]

You've also changed the column names, so make sure those are corrected - this is a valid formula now:

IF !IsNull([ADJ Pension Override Amt]) AND [ADJ Pension Override Amt] != 0 THEN [ADJ Pension Override Amt] ELSEIF !IsNull([ADJ Pension Override rates]) AND [ADJ Pension Override rates] != 0 THEN [ADJ Hours] * [ADJ Pension Override rates] ELSE [ADJ Hours] * [Pension Rate] ENDIF

[Lizbhernan]

@alexnajm Thank you!!! That worked 😊