Summary of a Maximum Value

[checkai]

I have a Maximum Value in an Employee group that I want to sum on in the Office group...

Office Sum(Max(amt.))
Employee Max(Amt.)
details... Amt.


I get a "The Summary / Running Total field could not be created" error.

Thanks,
DLC

 

[IdoMillet]

Crystal can't summarize summaries.

Use a formula in the group footer to increment a variable:
-----------------------------------------------------------
WhilePrintingRecords;
Global NemberrVar sum_of_max;
sum_of_max := sum_of_max + Maximum({amount}, {employee_id})
-----------------------------------------------------------

Use a formula in the Report Footer to show the total of the max values:
-----------------------------------------------------------
WhilePrintingRecords;
Global NemberrVar sum_of_max;
-----------------------------------------------------------

Cheers,
- Ido
CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com