>>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
If it's not broken, fix it until it is.
My Blog