CASE WHEN STATEMENT not working

[udles5666]

Hi Community,

I am stuck with a calculation (IF function). It throws an error below. 

Error: Formula (3): Parse Error at char(43): Invalid type in operator ==. (Expression #1)

IF [Result] = 0 THEN "No"
ELSEIF [Result] = 1 THEN "Yes"
ELSE [Result]
ENDIF

I cannot change the data type to double as it erases text. Can you please advise the workaround. Thanks

[grazitti_sapna · Accepted solution]

Hi @udles5666 , is this what you are loking for?

Formula:
IF [Result] = '0' THEN "No"
ELSEIF [Result] = '1' THEN "Yes"
ELSE [Result]
ENDIF

As the datatype of the field result is v_string so you need to pass the values in quotes and it will work.

Please refer to the screenshot and workflow attached.

Thanks.

[grazitti_sapna · Accepted solution]

Hi @udles5666,

Also if the yxzp file throws you an error of newer version you can always extract the file and then open the yxmd file in notepad and change the version to the one you are using.

Thanks.

[udles5666]

hi @grazitti_sapna 

That was easy! Silly me - Thanks!

[grazitti_sapna]

@udles5666 , welcome.