Error when trying to close an Else IF Expression

[Karl_Spratt]

Hi Folks,  I know you will think it's easy but I can't figure it out...Error when trying to close an Else IF Expression  when I but the ENDIF (F) on the word, my nice formula 🙂 goes into malformed expression, all the "code text " goes black.

See attached, anyone know how I can resolve this?

[JosephSerpis · Accepted solution]

Hi @Karl_Spratt try removing the " from 0.6 and 0 numeric arguments do not need quotes.

[jacob_kahn]

Oh the pain in the amount of times I've made this mistake! The suggested solution has been my savior multiple times!

[RobertOdera]

Hi, @Karl_Spratt 

Try this.

1.  add a select tool before the formula tool to profile the Type and Size of your data.

Notice is the data is Text, Number, Byte etc., and change accordingly if just a few fields (run Multi-Field Tool if changing many fields).

2. Nest fields in ToString() or ToNumber() as appropriate to avoid malformed expressions.

If a field value is a number then nesting it in "" or '' (double or single quotations) will result in malformed argument

If a field value is a text then NOT nesting it in "" or '' (double or single) will result in malformed argument

Looks like [%Available] is a number - remove quotations

If still doesn't work then that implies [Future Stockout Cal] is also a number - remove quotations as well

Should be good-to-go

Alteryx IF arguments end in ENDIF

Cheers!

[Karl_Spratt]

Bingo genius thank you all