Sum of Maximum Values in Groups 1

[GrandPaHiker]

I am new to Crystal Reports & need some help. I have a report similiar to the following. It is grouped on the customer # & displays the maximum price for each customers items in the group header. I need to total the maximum prices for all of the customers. In the example below it would be $75 + $65 = $140.

Thanks for any help you can offer.



Cust # Max Price
123456 $75.00
Part # Description Price
ABC Widgit # 2 $75.00
GHI Thing # 1 $55.00


Cust # Max Price
987654 $65.00
Part # Description Price
JKL Widgit # 1 $65.00
MNO Widgit # 3 $95.00

 

[briangriffin]

In the group header place this formula:

whileprintingrecords;
currencyvar y := y + Maximum ({PriceField}, {Customer # Field});

In the report footer place this formula:

whileprintingrecords;
currencyvar y;
y

 

[GrandPaHiker]

This worked perfectly!! Thanks for your help.