Problem with summarizing

[BradCustom]

I'm having a mental block on summarizing the following.

On my report I'm trying to summarize the maximum Total_Price for a given Quote Line. The formula I'm using to find the maximum is below.

maximum ({Quote_Qty.Total_Price},{Quote.Line})

This gives me the maximum Total Price for each line and now what I'd like to do is find the total for all lines.

Thanks for your help!

 

[lbass]

Use a variable. Create a formula {@summax} to place in the {Quote.Line} group header or group footer:

whileprintingrecords;
currencyvar summax := summax + maximum ({Quote_Qty.Total_Price},{Quote.Line})

Then in the report footer, use this formula {@display}:

whileprintingrecords;
currencyvar summax;

If your maximum is actually a number, not a currency, then change currencyvar to numbervar in each formula.

-LB

 

[BradCustom]

Thanks LB !!

That worked great!! I had created a variable but it was just to assign a variable to the maximum formula I created. I missed the "summax +" part of the formula.

Thanks again!!