Hi everybody,

I'm trying to create report for Top N clients where N is given by the parameter field. The detail section gives a revenue per client and in the report footer I'd like to have the sum revenue for the selected set of top N clients.
I created a following formula to calculate the sum:
Global NumberVar x3;
if recordnumber <= ToNumber({?Number of Customers}) then x3 := x3 + {@Accounts Receivables PrevYear}
else x3 := x3

The result in the RF gives me the sum of all records from Details but the value from the last record is added twice.

Does anybody know how I could handle this problem?

Thanks a lot.

J


Edited by jsismis - 27 Aug 2009 at 12:06am