Results 1 to 3 of 3

Thread: Rounding (2003)

  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    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. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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
  •