Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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%?
This uses proprietary data that we purchase. So I can't share the app with you unfortunately.
Share anonymized data in its raw form may be?
Just wanted to let you know that I changed the Totals Function for that measure from AVG to AUTO and now it displays the correct result.
Super