13 Replies Latest reply: Jan 3, 2017 1:32 PM by Sunny Talwar RSS

    Total not calculating correctly

    Mark Ritter

      I have a Master Measure that calculates a percentage for a column in my table.

       

      When I use this version the grand total is 17.0%

      (Count({<DestName={'SNF'}>} AGE)) /

      (Count(AGE))

       

      When I use this version the grand total is 20.1%

      //Aggr(Count({<DestName={'SNF'}>} AGE), ServiceLineDescription) /

      //Aggr(Count(AGE), ServiceLineDescription)

       

      The actual total is really 20.4% which I get when I calculate a variable with

      Num(Count({<DestName={'SNF'}>} AGE)/Count(AGE), '##0.0%') and display the result.

       

      Something is happening inside the table that is not happening in the variable.

       

      The calculation for each row for this % is correct.  It is just the total row that is off a bit. 

       

      What do I need to change to make the total correct with 20.4%?