help with expression

[adiarnon]

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

[kaushiknsolanki]

Hi,

Check this.

Recipe for a Pareto Analysis – Revisited

Regards,

Kaushik Solanki

[tresB]

+ With a real example Re: Pareto Analysis

[adiarnon]

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