Use IN rather than = in a variable

[matthewp]

I have a variable that SELECTS bottles.

sum({$<[PCC] ={"$(=concat([MCC],'","'))"},[RCPT] ={'Bottle'}>}[Amount]*-1)

I would like it to be able to select where it = bottle OR laptop

[sunny_talwar · Accepted solution]

May be this:

Sum({$<[PCC] ={"$(=concat([MCC],'","'))"},[RCPT] = {'Bottle', 'Laptop'}>}[Amount]*-1)

[tresesco]

Try:

sum({$<[PCC] ={"$(=concat([MCC],'","'))"},[RCPT] ={'Bottle' , 'laptop'}>}[Amount]*-1)

[Peter_Cammaert]

Don't be mistaken. The equal sign in a set modifier is an assignment operator, NOT a comparison operator. The values between curly braces get assigned to the field on the left as a sort of temporary selection. They do not compare to anything.

And just as with listbox selections, you select value1 or value2 or valueN in field RCPT...

Peter