Crystal Report 8.5 - Calculating the Sum of a Maximum value of a group

[Chinnymerlgrove]

I need some help calculating the sum of a group maximum values.
This is what I have…

Group 1 - Group data by EMPLID
Group 2 - Group by Company Code
For each company, the employee has accumulated monthly earnings. So to get the maximum earnings per company I do step 3.

Step 3 - Insert Summary of the Maximum Gross YTD Salary by Group 2 The fromula I am using is as follows:
((Maximum ({PS_EARNINGS_BAL.GRS_YTD},({PS_EARNINGS_BAL.COMPANY}) )))

I tried writing a formula to get the total for Duck, Donald based on Step 3. I cannot do a regular SUM function as it will total all the monthly earnings which would make the total inflated. The result should be as follows for employee Donald Duck.

Maximum Gross YTD for Co 1 = $6,700 +
Maximum Gross YTD for Co 2 = $8,760
= $15,460

My formula is as follows Sum (Maximum ({PS_EARNINGS_BAL.GRS_YTD}, {PS_EARNINGS_BAL.COMPANY}),({PS_EARNINGS_BAL.EMPLID}) )

My formula produces an error that says “Summary/Running Totl field could not be created".