5 Replies Latest reply: Sep 1, 2017 4:31 AM by Ronald Janssen RSS

    Measurement Total in report is not equal to sum of details

    Ronald Janssen

      Hello,

       

      I'm facing a problem with Qlik Cloud. My report has the following layout:

       

      Holiday                                        30

           Not billable                              30

                Employee 1                         8

                Employee 2                        40

       

      Holiday, Not billable, Employee 1 and 2 are dimensions of the report, while the numbers represent the hours and this is a measure. The formula of the measure is sum(quantity).

      The total of Holiday and Not billable should be 8 plus 40 is 48. In the report another number is shown, in this case 30.

      Do anybody why the totals are not calcuclated the right way?

       

      Kind regards, Ronald Janssen.