Hi Naomi
Rounding is always a pain. If possible avoid rounding. In either case explaining to clients is an even bigger pain. If possible calculate your commission on each and every item in the invoice (I presume) and then total that and store in your table. This will raise the issue that the comm. calc. in the invoice does not match the calculator value, but I believe you will be able to reduce the $5 diff. to something much lower, even with rounding in the report.
>
>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...