report: wrong sum with aggregate function
Baan: Baan IVc4
I have a strange problem. I have a report with the Layouts Before.report, Detail and After.report. In the After.report Layout i have 4 fields where i use the aggregate function (the domain is tc mcs.double and all field settings are the same). 3 of these fields show the correct sum, but one shows a false sum. The sum is almost twice of the amount it should be (but not exactly). Any ideas what the reason could be?
Thanks in advance!