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

using currency with sum only.
don't directly multiply a currency with a number, uses

SUM(NTOM(MTON(currency)*number ))

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