>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! :-)
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.