Help with an if statement

[RR8]

Hi 

Please can anyone advise what is wrong with my formula below

IF LEFT([Code],1)='I' THEN ABS([TransAmount]

ELSEIF LEFT([Code],1)='Z' THEN ABS([TransAmount]

ELSE ABS([Base_Amount] ENDIF

Thanks

[Deano478 · Accepted solution]

Hey @RR8 it looks like your maybe missing some closing brackets give this a try and let me know if it works?

IF LEFT([Code],1)='I' THEN ABS([TransAmount])
ELSEIF LEFT([Code],1)='Z' THEN ABS([TransAmount])
ELSE ABS([Base_Amount]) ENDIF

[RR8]

You are fantastic thanks so much

[Deano478]

No problem at all your very welcome