Alteryx Designer Desktop Discussions

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

Help with an if statement

RR8
7 - Meteor

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

 

3 REPLIES 3
Deano478
12 - Quasar

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
7 - Meteor

You are fantastic thanks so much

Deano478
12 - Quasar

No problem at all your very welcome

Labels