We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
fireworks
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