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
Solved! Go to Solution.
"<>" does not work in Alteryx - try "!="
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
@alexnajm Thank you!!! That worked 😊
User | Count |
---|---|
52 | |
27 | |
25 | |
24 | |
21 |