Variables returning either numeric or text value

[#1]

Hi All,

Have been able to define a number of variables.

When using predefined numeric values, I am able to extract this value and evaluate it appropriately.

HOWEVER, when using text values as a pre-defined list, I am unable to evaluate whether a particular condition has been met.

Please see attached file for clarification...

Anyone have any ideas?

Please advise,

Kind regards,

Rich

[Miguel_Angel_Baeyens · Accepted solution]

Hello Rich,

When the variable stores a literal string, it doesn't need to evaluate it, so you can call it without expanding.

=if(zz_Display='Annual',100,0)

Hope that helps.