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

pension adj calc.yxmd

alexnajm

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