Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this:
Sum({$<[PCC] ={"$(=concat([MCC],'","'))"},[RCPT] = {'Bottle', 'Laptop'}>}[Amount]*-1)
May be this:
Sum({$<[PCC] ={"$(=concat([MCC],'","'))"},[RCPT] = {'Bottle', 'Laptop'}>}[Amount]*-1)
Try:
sum({$<[PCC] ={"$(=concat([MCC],'","'))"},[RCPT] ={'Bottle' , 'laptop'}>}[Amount]*-1)
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