topic Re: Combine Set Expressions in App Development

Combine Set Expressions

leobrand — Fri, 15 Dec 2017 03:13:59 GMT

I want to create a set expression that includes customers that purchased “Running Shoe A” while excluding customers that purchased this shoe from the vendor “Sporting Goods Store”. Can you help me combine the set expressions below into one in order to do this?

Sum({1<Customer=(P({1<ProductName={Running Shoe A}>}))>}LineSalesAmount)

Sum({1<Customer=(E({1<Vendor={Sporting Goods Store}>}))>}LineSalesAmount)

Re: Combine Set Expressions

sunny_talwar — Fri, 15 Dec 2017 12:37:58 GMT

May be this

Sum({1<Customer=P({1<ProductName={Running Shoe A}>})*E({1<Vendor={Sporting Goods Store}>})>}LineSalesAmount)

Re: Combine Set Expressions

sunny_talwar — Fri, 15 Dec 2017 12:56:19 GMT

Or one of these

Sum({1<Customer=P({1<ProductName = {'Running Shoe A'}>})*E({1<Vendor={'Sporting Goods Store'}, ProductName = {'Running Shoe A'}>}), ProductName = {'Running Shoe A'}>}LineSalesAmount)

Sum({1<Customer=P({1<ProductName = {'Running Shoe A'}>})*E({1<Vendor={'Sporting Goods Store'}, ProductName = {'Running Shoe A'}>})>}LineSalesAmount)