I have created a report where in the Group footer I have added the following fields (they are sums of the detail) units sold, sales , unit price, average price, Since I took the sum of the group for sales,divided by the sum of the group for units sold to get the average price i can not do a sum in the report footer. Can anyone help me get a sum of the average price?

Create a formula and place it in GF

Sum of sales/ Sum Units sold

Use sum fields(sums of the detail) which are group footer in the above formula instead of creating sum on average price field..

HTH,
Jyothi