Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.

Conditional if statement

Highlighted
5 - Atom

I am having trouble with an if statement using the formula tool.  I am getting the nasty "Malformed If Statement" error.  I am trying to build a forecast model and this if statement is not working!  What am I doing wrong?

IF [Sum of % Chg]= -1, THEN [Sum of 07/2017]*21/20, ELSE [Sum of 07/2018]*21/19, ENDIF

 

Thank you in advance

Highlighted
Alteryx
Alteryx

Hello,

 

I imagine it is the comma you are using in your formula.

 

Try using this....

 

IF [Sum of % Chg]= -1 THEN [Sum of 07/2017]*21/20 ELSE [Sum of 07/2018]*21/19 ENDIF

 

Nick

Highlighted
5 - Atom

OMG, Thank you so much.  I have been staring at this for an hour and did not even notice those comma's.

It works perfectly without those!!

Labels