Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want calculate an index DP%.
numerator =
Total customers turnover supplied by the wholesaler who bought an article.
Denominator
total turnover of the wholesaler
Example
Numerator = 30565
Denominator=1927067
DP=1.5%
if I select one item, my formula is correct
if I don’t select one item,it not work.
can you help me
thank you
The %DP calculation is a bit weird (disable the Total, because it will produce garbage), but you can try with this expression:
=sum(aggr(sum({<COD_ARTICOLO=>} TOTAL <COD_FILIALE,COD_ESERCIZIO> FATTURATO), COD_FILIALE, COD_ARTICOLO, COD_ESERCIZIO)) /
aggr(sum({<COD_ARTICOLO=, COD_ESERCIZIO=>} TOTAL <COD_FILIALE> FATTURATO), COD_FILIALE, COD_ARTICOLO, COD_ESERCIZIO)
Peter,Your formula works.
Thank you very very much
Hi,
Please close the thread if u got the solution
chk below link
Peter,
can you write a correct formula for the total?
please