>Jim,
>
>Looks like the discrepancy exists for the particular Reference number only. Somehow the original data in the table don't match my calculatations. In all other 51 cases they match exactly.
That's possible only if there are no cut off decimals - i.e. the total number of non-zero decimals when you multiply the amount with the percentage is never more than two. 1% of $1 is always $0.01, and there's no rounding. 0.1% of $10 is also exactly $0.01 etc. However, if there are some hidden decimals - the "match exactly" may be what you see displayed and not what's actually stored in the variable during the calculation. You may be running under a Set("decimal")=2 and it may look right, but the jagged decimals may simply be not displayed.
Try running your report with just those 51 cases, to see if they really do match. Run it with random selection of other cases, see if it always matches.