You have to create a formula that is a manual running total. Put the formula in the group footer so that everytime you print the Max() value, then you add it to the running total. At the end of the report calculate the average of the entire quantity (use Global variables so that you can keep track of the formulas as the report runs).

I would create a counter to track how many machines are in the group. Then  create a formula that uses a global variable that gets incremented each time it is called. Put this formula in the group footer. Then create another formula which simply prints the global variable.

The first formula might be:

Global NumberVar NumGroups;
NumGroups := NumGroups + 1;

Glad it worked.

Thanks for wanting to buy the book (book sales support this site and keep me answering questions). Just click on the banner ad on any page and it takes you to Amazon. 

Wait, I see that you're from the UK. Well, you can get it at Amazon.co.uk then. Thanks.


Edited by BrianBischof - 25 Oct 2007 at 12:21pm