CASE WHEN STATEMENT not working

Question

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

Nested IF Function.yxzp

grazitti_sapna · Accepted Answer

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 Answer

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.