Parse Error at char(0): IN(...) Parameter #1 has a type mismatch.

[Tim6]

Hi There, 

I am encountering some issues with this formula: 

IF [Old Goal] IN("1","2","3") and [New Goal] >= 8 THEN "Yes" ELSE "No" ENDIF

I keep getting this error: Parse Error at char(0): IN(...) Parameter #1 has a type mismatch. 

But i have checked the data type of the input using the select tool and it is double.

This is consistent with the datatype i used in the formula.

Please help.

Thank you.

[AbhilashR]

Hi @Tim6, Alteryx doesn't like double quotes if the incoming column is a numeric value (int, double etc.). It needs double quotes only when the column is a string (or variant of string) datatype. The following formula would be applicable in your case - 

IF [Old Goal] IN(1,2,3) and [New Goal] >= 8 THEN "Yes" ELSE "No" ENDIF

[Tim6]

Thank you very much @AbhilashR.

It works, but i don't think my new column was added because there is nothing in the data preview. 

Please let me know what you think 

[AbhilashR]

Hi @Tim6, would you be able to share an anonymized version of your data for us to look at? Attached is a sample implementation of the formula logic.

[Tim6]

Thank you so much @AbhilashR, it works now - I changed the data type to V_WString.

[AbhilashR · Accepted solution]

Thank you for reaching out to the Community! Please mark this post as a solution accepted if you don't mind.