Matrix returns wrong total as a result of rounding numbers.

[PoojaG]

Hello,

Is there a simpler solution for what I think is a simple problem?

Problem: I have a matrix table with three categories at row level and around 5-6 measures. For the measures where there were decimal points rounted to 0, the total is miscalculated. As an below example: Notice the last column is in decimals.

Department# employees% expectedActual

Sales	61	0.4	24.4
Marketing	3	0.6	1.8
Finance	2	0.6	1.2
HR	1	0.2	0.2
Total			27.6

When I make the decimals 0, I get below: Notice the total. It should have been 27. To calculate the % I did use Sumx(Master,(# employees * % expected)). Is there a simple way of achieving this. I did follow this blog but I have way too many measures to incorporate the changes. I'm looking for a cleaner solution if that's even possible. 

Department# employees% expectedActual

Sales	61	0.4	24
Marketing	3	0.6	2
Finance	2	0.6	1
HR	1	0.2	0
Total			28

 thank you!

[danextian · Accepted solution]

Hi @PoojaG 

Incorporate the rounding within your sumx formula and not just in the formatting. That should be something like

Sumx(Master,round(# employees * % expected),0))

[lbendlin]

If you want the result to be 27 then you need to implement your own integer math.