Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello.
I am facing a problem with the aggr command.
I attach a qvw that i have some data and in the level of item the aggregation is correct about the summary of maximum QTY,
but when i create a chart in the level of promo code i miss in the promo 517085 the QTY 2 that summarized in the other promos.
When i select only the promo code 517085 the result is correct QTY 2
Can anyone help me to find a solution ?
Thank you in advance.
Not really sure what you want to calculate, but maybe you need the NODISTINCT qualifier here:
=SUM(aggr(NODISTINCT max(QTY),SALE_NBR,SALE_LINE))
Not really sure what you want to calculate, but maybe you need the NODISTINCT qualifier here:
=SUM(aggr(NODISTINCT max(QTY),SALE_NBR,SALE_LINE))
It is correct.
Thank you very much.