Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Formula error

Lizbhernan
8 - Asteroid

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

 

3 REPLIES 3
alexnajm
18 - Pollux
18 - Pollux

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

alexnajm
18 - Pollux
18 - Pollux

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
8 - Asteroid

@alexnajm Thank you!!! That worked 😊

Labels
Top Solution Authors