Multi-Box Expression

[Anonymous]

Hello,

I am trying to write an expression in a multi-box to only include certain products in the product drop-down.

Write now I have:

=Product='RRMD' or Product ='RZT'

This works, but instead of the text showing up, the product drop-down only shows 0 and -1. How can I get this to show the text values in the drop-down?

[datanibbler · Accepted solution]

Hi,

well, 0 and -1 are the boolean values for FALSE and TRUE, respectively. Just change your expression to

>>>  = IF((Product='RRMD' OR Product='RZT'), Product) <<<

HTH

Best regards,

DataNibbler

[Anonymous]

I solved it by making it an if statement.

=if(Product='RRMD' or Product='RZT'),Product)

[Anonymous]

Thank you!