Perhaps I'm missing something simple here. I have a report that consists of only the Sub-summary part, no body. The report gives totals for how much was received for each item in inventory over a period of time using summary fields such as Total_of_Extended_Price. This report is in the line items file for the orders, by the way, so each record is a line item on an order.

How can I get the average of the summary field. For instance, in the report I''m looking at, there were six different items that were ordered, so the sub-summary part shows up six times and gives the totals for each, even though the number of items that report covers could be hundreds, there are only six unique items. The grand total is, let's say, $12,000. How can I get that on average an item brought in $2,000?

I hope I'm being clear.

Thanks,

Chuck

Am I wrong in suggesting a summary field that averages the costs? Then placing that summary field in the Grand Summary Part. Or am I missing something.