8 Replies Latest reply: Dec 18, 2014 9:06 AM by Mohamed Ahid

# how to get the number of bills that are 80% of my turnover

HI all

i'm trying to do a calculation on a table .

I have a bill's table and i want to get the number of bills that makes almost 80 % of my total revenue .

exemple :

in my bills table i have 100 000\$ of revenue  and 63574 bills . the result must be like this way :

57489 of bills = 80 000 \$ and 6085 of bills = 20 000 \$ .

How can i acheive that plz?

thanx

• ###### Re: how to get the number of bills that are 80% of my turnover

See this blog post: Recipe for a Pareto Analysis

• ###### Re: how to get the number of bills that are 80% of my turnover

=Count(If(Aggr(RangeSum(Top(Sum(Amount), 1, RowNo())) / RangeSum(Top(Sum(Amount), 1, NoOfRows())), Bill) < 0.8, Bill, Null()))

The above expression will give you COUNT Of bills covering 80% amount of total bills

Below will give you for rest 20%

COUNT(TOTAL DISTINCT Bill)-Count(If(Aggr(RangeSum(Top(Sum(Amount), 1, RowNo())) / RangeSum(Top(Sum(Amount), 1, NoOfRows())), Bill) < 0.8, Bill, Null()))

• ###### Re: how to get the number of bills that are 80% of my turnover

Manish , in my case i dont have a bill number , i tried a recno and it's giving nothing .

Anu idea or suggestion ?

Thx

regards

• ###### Re: how to get the number of bills that are 80% of my turnover

Provide Sample data to work...

• ###### Re: how to get the number of bills that are 80% of my turnover

Here .

thanx