adding totals in a report column and off 1 cent

  • Thread starter Thread starter kelly
  • Start date Start date
K

kelly

When adding a column of extension in my report. The total
a lot of times is off one cent. I'm thinking because of
rounding and decimal places. I have set all at two and
currency and it still is off one cent. How do I get the
total to only add what is viewed so if my customer adds
the columns we come to the same amount?
Thanks,
 
kelly said:
When adding a column of extension in my report. The total
a lot of times is off one cent. I'm thinking because of
rounding and decimal places. I have set all at two and
currency and it still is off one cent. How do I get the
total to only add what is viewed so if my customer adds
the columns we come to the same amount?
Click to expand...

Generally, you need to add the rounded values. You didn't
say how you calculating the total, but if you're using the
Sum function, it might be something like:

=Sum(Round([amount], 2))
 
Back
Top