1. ## Rounding (2003)

On a report, I have a number 90,186 divided by 193,254. I get 0.4666708 which rounds up to 47% on the report. Is there a way not to get it to round and just be 46%? My graph is not rounding and the report is. I add up all the percents and they add up to 101% on the report. On the report, I have a calculation =[contracts]/[tot].

2. ## Re: Rounding (2003)

When you are rounding numbers, it is unavoidable that sometimes, the sum of the rounded numbers doesn't equal the sum of the unrounded numbers. For example, say that you have the following percentages:

49.6%
39.6%
10.8%

If you add them, you get exactly 100%. But if you round to whole percents, you get

50%
40%
11%

which adds to 101%. In general, it is best to explain why this happens instead of manipulating the results. Alternatively, you could develop an algorithm that changes the number with the least relative impact. In the above example, you would round 49.6% to 49% because the relative change from 49.6% to 49% is smaller than the relative change from 39.6% to 39% and the relative change from 10.8% to 10%.

On your report, you could use =Int(100*[Field1]/[Field2])/100 to truncate the result of Field1/Field2 to 2 decimals.

3. ## Re: Rounding (2003)

Thank you.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•