adding totals in a report column and off 1 cent

[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,

 

[Marshall Barton]

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?

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))