>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...
I think you should look at all intermediate results. Probably you must round all intermediate results to 2 decimals as well, to get exactly the same results in both cases.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)