1

I have a variable in an expression that SELECTS bottles.

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

I would like it to be able to select where RCPT equals bottle OR laptop.

Matt
  • 14,906
  • 27
  • 99
  • 149

1 Answers1

1

The IN values need to be contained in {'value1', 'value2', 'value3'....etc} but still using RCPT =

Sum({$<[PCC] ={"$(=concat([MCC],'","'))"},[RCPT] = {'Bottle', 'Laptop'}>}[Amount]*-1)
Matt
  • 14,906
  • 27
  • 99
  • 149
  • if you add [RCPT] *= {'Bottle', 'Laptop'} then you can even have the expression respond to selections of either Bottle or Laptop as well – The Budac Jun 09 '19 at 14:35