How to Average a Group Maximum Values
Posted on 2011-03-25
I have a report that is grouped on a LoadID field (multiple rows per LoadID, each row containing a Mileage field). For each LoadID group, I use a running total to display the maximum Mileage for that LoadID.
Now, in the footer of the report, I want to put in the average of these Maximum values (i.e. average the maximum Mileage for each LoadID). I can't use a running total or a summary field on the running total field that I used to display the maximum mileage per load, as per Crystal capabilities.