Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=SUM({<[prmBUYERTYPE]-={'STH', 'COMP'}>} prmTIXQTY)
=SUM({<[prmBUYERTYPE]-={'STH', 'COMP'}>} prmTIXQTY)