currency total

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Im adding currency in a report. Like many other posts the problem is that
damn penny off! I want the calculation accurate to the penney. How can i do
this?
 
Bill said:
Im adding currency in a report. Like many other posts the problem is that
damn penny off! I want the calculation accurate to the penney. How can i do
this?
Click to expand...


The individual number on each detail is rounded for display
purposes, but the total adds up the unrounded numbers. In
mathematical terminology:
Sum(Round(x)) is not equal to Round(Sum(x))
This means that the total is technichally more accurate than
you are when you add up the detail numbers.

But, you probaly don't care about that kind of accuracy ;-)

All that foldorol aside, change your total text box
expression from Sum(amount) to Sum(Round(amount))
 
Back
Top