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

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

    Mohamed Ahid

      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