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
Solved! Go to 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
You are fantastic thanks so much
No problem at all your very welcome