4 Replies Latest reply on Jul 17, 2018 1:06 AM by Keir Blockley

# How to calculate percentage based on rounded numbers

Hi

I have used the following rounding calculation to round number of records to the nearest 5:

Round(SUM( [Number of Records] )/5)*5

Unrounded count of 3 for white correctly becomes rounded count of 5 and unrounded count of 14 for BAME correctly becomes rounded count of 15.

When I add in a table calculation for percentage of total of table across based on the rounded number, I would expect the percentage values to be 25% white (based on 5 out of 20) and 75% BAME (based on 15 out of 20). Instead I get 33.3% for white and 100% for BAME.

What I imagine is happening is that the total is based on 17 (3 white + 14 BAME), which is then being rounded to 15. The percentage is then calculated on white 5/15 = 33.3% and BAME 15/15 = 100%.

Please can someone advise how to get the percentages to be 25% white and 75% BAME.

Thanks

Keir

• ###### 2. Re: How to calculate percentage based on rounded numbers

Hi Keir,

Is that what you're looking for?

Let us know if this help.

Mahfooj

• ###### 3. Re: How to calculate percentage based on rounded numbers

Hi, Keir

Please find my solution attached as well as below screenshot for reference.

Hope this helps

ZZ

• ###### 4. Re: How to calculate percentage based on rounded numbers

Zhouyi - thanks for your answer, that is exactly what I needed, as it means I can use one calculated field and then split it by different dimensions.

Mahfooj/Bharat - thanks for answering as well.