Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
I solved it by making it an if statement.
=if(Product='RRMD' or Product='RZT'),Product)
Thank you!