<div>
Excellent! &nbsp;Worked Great! &nbsp;I id have to change the MileageTotal calculation in the group footer formula to <br />
<br />
MileageTotal := MileageTotal + {&amp;MaxRunningTotal}<br />
<br />
Without that change, the MileageTotal was alwas equal to the value of the last row.<br />
<br />
Thanks again!
</div>


Excellent!  Worked Great!  I id have to change the MileageTotal calculation in the group footer formula to

MileageTotal := MileageTotal + {&MaxRunningTotal}

Without that change, the MileageTotal was alwas equal to the value of the last row.

Thanks again!

<div>
Sorry. &nbsp;Typing too fast.<br />
<br />
mlmcc
</div>


<div>
<div class="content wysiwyg-content">
I have a report that is grouped on a LoadID field (multiple rows per LoadID, each row containing a Mileage field). &nbsp;For each LoadID group, I use a running total to display the maximum Mileage for that LoadID.<br />
<br />
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. &nbsp;<br />
<br />
Any suggestions/questions?
</div>
</div>


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.  

Any suggestions/questions?

How to Average a Group Maximum Values

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.