Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi i have a set of data with a duplication. Now would like to sum a price.
the situation is like this:
1. Book -> Purchase
2.Book -> Purchase -> Cancel
3. Book -> Purchase -> Terminate
if i select Book, it is correct to use sum(aggr()).
But, if i select Purchase, i would like to exclude cancel and terminate from the sum.
Please help.
Not entirely sure, but may be you need this
If(status = 'purchase',
sum(Aggr(Only({<saleid = e({1<status = {'cancel', 'terminate'}>})>}price),saleid)),
sum(Aggr(price,saleid)))
Not entirely sure, but may be you need this
If(status = 'purchase',
sum(Aggr(Only({<saleid = e({1<status = {'cancel', 'terminate'}>})>}price),saleid)),
sum(Aggr(price,saleid)))
Thank you Sunny, u have been very helpful. Thank you so much