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