Multiple Variables

[evansabres]

Hello -

I have a field, '[Buyer Type Code]'

I want to do a sum of quantity of tickets sold for [Buyer Type Code] where [Buyer Type Code] is not equal to several variables. The variables I want to include are 'STH' 'COMP' and 'EMPCOMP'

How do I enter an expression to have a sum not equal multiple variables.

Currently, I have

=SUM({<[prmBUYERTYPE]-={'STH'}>} prmTIXQTY)

to return all values not 'STH'. So, I just want to include two variables (any maybe more down the line)

Thank you

[maxgro · Accepted solution]

=SUM({<[prmBUYERTYPE]-={'STH', 'COMP'}>} prmTIXQTY)