I have two amount fields in the details, i am taking the avarage of those two and placing at in group header, now i want to take the difference of these two avagrage values, i have written a formulae but it is not working properly.
for eg:
positions totalrevenue totalctc customer
2 2000$ 1500$ abc
1 3000$ 2800$ xyz
50 30000$ 25000$ abc
7 900$ 750$ pqr
so i want to take avarage of total revenue and totalctc, also need difference of those avarage values in groupheader i.e in customer group
Thanks