Forcing Crystal to evaluate a formula at group level 1

[Gopan]

I'm trying to insert a formula into a group footer forcing my report to display the largest absolute value for a column for each group (i.e. for each customer show the largest absolute value of rating). However, the formula appears to be evaluating the formula after the entire data set has been displayed. For example, I select a certain Classification group which has 3 customers. Instead of choosing the largest absolute value for the column for each customer, it calculates that largest absolute value for ALL the customers and puts that value into the summary column for all of the customers.
eg. Customer A: Largest value = -100
Customer B: Largest value = 75
Customer C: Largest value = -80
In the above example instead of putting each of the values in the footer under each of the customers, it will put 100 as the largest absolute value for all of the customers.
This suggests that the formula to calculate the largest value is not being evaluated at the group level, which is where it is, but at the very end for all of the data.
Long explanation but I hope someone can help. Thanks.

 

[IdoMillet]

You are probably using something like:
---------------------------------
Maximum ({@Abs_Value})
---------------------------------

Instead, you should be using:
---------------------------------
Maximum ({@Abs_Value}, {Cust_ID})
---------------------------------

The second argument tells the Maximum function it should compute the maximum of the Abs_Value formula for the Cust_ID (the Cust_ID in the section this is evaluated).

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

http://www.MilletSoftware.com

 

[Gopan]

Thanks Ido, worked like a charm.