>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.
>
Hi Bhavbhuti,
Thanks a lot for your response. I removed rounding from my calculations, but it didn't change the picture (may be just in few cents) and I still have a discrepancy. Looking at the individual detail lines I noticed, that in case of one category the Commission Paid and the Commission Paid by Category (this is what I'm trying to calculate) match in majority of cases (AFAIK I found few not matching already). If I have more than one category I found several cases of mismatch already, though the cases I found have a negative difference (e.g.
Commission Paid >=Cat1+Cat2+Cat3... and in the total picture I have
Commission Paid + $5 = Cat1+Cat2+Cat3
something is definitely wrong, but I'm not sure if my original data are trustworthy...
I think I would add something into this report to highlight mismatching cases.
Thanks.
If it's not broken, fix it until it is.
My Blog