find maximum of formula output 1

[mollyk]

I am somewhat new to CR, but was able to create a formula successfully. the problem is I would like to find the maximum of the values found in that formula.
When I go to summarize, the @ variable is not listed. any ideas? here is my formula:

whileprintingrecords;
numbervar prev;
numbervar current;
numbervar formula;
prev:=previous({history_112004.inVal});
current:={history_112004.inVal};
if (prev=0 or (prev>current))
then formula:=0
else formula:=current-prev;

 

[lbass]

Create these formulas:

//{@max} to be placed in the details section:
numbervar formula;
numbervar max;

if onfirstrecord or
formula > max then
max := formula;

//{@displmax} to be placed in the group or report footer:
whileprintingrecords;
numbervar max;

If you are using a group, then you would want to reset the variables by placing the following formula in the group header:

whileprintingrecords;
numbervar prev := 0;
numbervar current := 0;
numbervar formula := 0;
numbervar max := 0;

-LB

 

[mollyk]

thank you, that worked perfect!