Malformed IF statement when I add ENDIF

Question

Can someone help me understand why when I add the ENDIF to the end of my statement, everything following the 2 then 'Plan 2 activation date' "etc... become unhighlighted. I then see the parse error at char(153): Malformed If statement. Oddly enough, when I remove the ENDIF the entire conditional function is highlighted, but of course, it can't perform if it doesn't have an ENDIF for an IF ELSE function.

I have tried using both the formula & filter tool to perform this.

IF [Red_flag] = 'Y' then 'Red_flag Activation'
ELSEIF [AC_Min] = 1 then 'Plan 1 Activation Date'
elseif [AC_Min] = 2 then 'Plan 2 Activation Date'
ELSE ToString([PLAN_id]) ENDIF

Adrian_T · Answer

Hey @Dcaston,

All the replies from @DataNath, @Felipe_Ribeir0 and @apathetichell should help you debug your nested IF formula just fine. 😊 I just thought to also share a great alternative formula that would help you simplify complex nested IF formulas in future.

This will definitely be dependent on your own preference, but I personally like using the IIF conditional statement instead. You can nest another IIF statement as a replacement for y, and just like that you remove the need, and more importantly any possible typos for "THEN", "ELSE", "ENDIF" etc. 😎

IIF(bool, x, y): Returns x if bool is true, else returns y.

apathetichell · Answer

the error is occurring at 153 - if this was related to AC_MIN being a string - the error would be at 114. Your statement is running fine on 21.4. I'd check for the following:

1) Are all of your fields separated by a space from the boolean terms/operators?

2) What happens if you swap elseif to ELSEIF

Basically try cutting and pasting into formula tool what you posted here.

Felipe_Ribeir0 · Answer

Hi @Dcaston

The AC_Min field on your workflow is being interpreted as a string field, so or you put the numbers between quotes on your formula ([AC_Min] = '1'), or you transform the field into a numeric field with the select tool.

Malformed IF statement when I add ENDIF.yxmd