4 Replies Latest reply: Nov 13, 2015 9:25 AM by Massimo Grossi RSS

    Total in an expression

    Darri Hilmarsson

      Hi, QV

       

      I have one problem that I don't know he solution.

      I am seeing if you can figure it out.

       

      I have this dataset. I have information of number of invoices for every category and company.

       

      CompanyCategoriesNo. of invoices
      1000Intercompany42787
      1000Scanned17894
      1100Emailed PDF3773
      1100Scanned12608


      I want to know e.g.

      How many invoices in percentage are scanned for company 1000 of total invoices for company 1000.

      The answer I am looking for is:

      Scanned Invoices for company 1000/ Total Invoices for company 1000 = 17894/60681 = 29,4%

       

      I tried to use this formula: =Sum([Number of invoices])/Sum(Total [Number of invoices])

      But it does not give me the right answer because in the formula: Sum(Total [Number of invoices]

      I get all the invoices.