Set Analysis, Multiple Expressions

EvanBarrick — Thu, 28 Mar 2019 13:11:46 GMT

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.

Re: Set Analysis, Multiple Expressions

PV — Thu, 28 Mar 2019 13:27:53 GMT

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

Please explain in detail if you have any specific requirements.

topic Re: Set Analysis, Multiple Expressions in App Development

Set Analysis, Multiple Expressions

Re: Set Analysis, Multiple Expressions