Summary Rounding

[kshelton]

Summary is giving a different figure to the figures on the list of records selected. Example

Record 1 = 200.15 (actual 200.153)

Record 2 = 100.75 (actual 100.754)

Total = 300.90 but Summary gives 300.91 as it is picking up the 3rd decimal place to make up the extra 0.01.

How do I make Summary ignore the 3rd decimal place?

Any suggestions appreciated.

Keith

Edited February 18, 2009 by Guest

[comment]

A summary field (or function) summarizes actual data, not what happens to be displayed on the layout level. The actual result of your summary is 300.907. It only shows as 300.91 because it too is formatted that way.

If you want to remove this discrepancy, you'll need to ROUND the actual data, not just make it pretty for the layout. Assuming that the amounts 200.153, 100.754 etc. are the results of a calculation, change the calculation's formula so that it rounds the final result to a precision of 2.

Keep in mind that this works on the data level, and once rounded you can never go back. If you need the data with its original precision elsewhere, you will have to use a second calculation field just for the rounding, and summarize it separately.

[kshelton]

Thanks very much.

I was just about to post to say that I had fixed it with a Round function when I saw your reply.

At least you have confirmed that I have done the right thing and also given me more info on the subject.

Thanks again.

Keith