Set Analysis, Multiple Expressions

[EvanBarrick]

I have three fields that I want to incorporate into a set analysis expression; PRICE_SCALE_CODE, PRICE and QTY

I want to get the QTY when the PRICE_SCALE_CODE = 'SUITE' and the PRICE > '0' and then subtract the QTY when the PRICE_SCLAE_CODE = 'SUITE' and the PRICE < '0'.

What would the structure of the expression be? I have the basis of the expression, Sum ({< PRICE_SCALE_CODE = {'SUITE'}>}QTY) working, but I am having difficulty expanding on this.

[PV · Accepted solution]

Basic expression
=sum({<CODE={'SUITE'},Price={">0"}>}Quantity)-sum({<CODE={'SUITE'},Price={"<0"}>}Quantity).

Please explain in detail if you have any specific requirements.