Ok, now everything works just fine. Apparently they were also paying commissions for Memos, not for invoices only.

>>>>Hi everybody,
>>>>
>>>>I have a field Commission paid in the table. For my report I also re-calculate commissions based on category. I use currency fields for commissions and I round the numbers by 2. Now the total commissions paid (which is near 10K) doesn't match the sum of totals commissions by category by $5.
>>>>
>>>>I'm wondering, should I try to not round my commissions in the calculations? The total commission paid field is Numeric (11,2).
>>>>
>>>>What do you think about this problem?
>>>>
>>>>Thanks in advance.
>>>>
>>>>UPDATE. Without the round the difference is only in the last digits (cents portion), so I lost $5 somehow in my calculations...
>>>
>>>Do rounding only at the end. Do any multiplication before division (each time you divide, unless pure even numbers, you can get a rounding error, compounded if several - so best just do once at end)
>>>
>>>You were short $5? Out of how much?
>>>
>>>Thought of taking up accountancy as a career? ..... Don't! :-)
>>
>>Out of 10K. E.g I have total commissions paid 9,819.20 and sum by categories gives me 9,824.07
>
>Naomi, is this summing in a report or in a prog/method? Each commission field that you're adding up - is there a constraint on the number of dec. places, so rounding is implicitly happening there (See I don't know how many comm's you're adding). Hence, would making each comm. field with more dp help, then the result is rounded to 2 dp just at the end.