Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
in my purchase module
i have suppliers and the purchase order from each supplier
i wan to calculate-
whats the percentage of suppliers that constituting 80% of my purchase
what expression should I use?
tnx,
adi
Hi,
Check this.
Recipe for a Pareto Analysis – Revisited
Regards,
Kaushik Solanki
+ With a real example Re: Pareto Analysis
tnx,
its help but I still have a problem
i need the result in a text box not in a graph
in the example you gave me i can do-
Top 20% of the suppliers are worth 91.7% of total purchase
the expression give me the 91.7%
Num(Sum({<Central_BP = {"=Rank(Sum(USD_AMNT_BY_PO_RATE)) < (Count(TOTAL DISTINCT Central_BP)*0.20) + 1"}>}USD_AMNT_BY_PO_RATE)/Sum(USD_AMNT_BY_PO_RATE), '##.0%')
i need the opposite-
Top ??% of the suppliers are worth 80% of total purchase
how can i calculate the ??%
tnx.
adi