>It depends, if you wrote a some kind of accounting system, no matter where you are you must be precise to a penny.
The original field is Numeric 11,2 The calculations are done without rounding, so I'm not sure what is put into this field since it only can hold 2 digits.
I'm using currency fields for my calculations and no rounding as well.
So, the report shows Commission paid $9819.20 (this is from the table, using report field with sum option) and I have totals by categories (also using fields with sum option), the sum of these totals gives me 9818.88 which gives me -0.32 difference, which is not that good. However, since the original field in the table is numeric and not currency, I'm not sure if I can achieve the precise numbers.
If it's not broken, fix it until it is.
My Blog