Trying to get the largest summary of groups 1

[Doris]

I have a report that is grouped by state with a summation of the balances in that state. I am trying to get the state with the largest balance in the footer. I tried using maximum or nthlargest but it won't let me use the summed field. Any suggestions? Thanks

 

[leatherbag]

create a formula

if previous (record1) > (record2) then (record1) else (record2)
in this way you should be able to capture the largest number in the formula

 

[Doris]

I am confused. I have a detail section that is grouped on the state. I have a total of the "balances" on the group footer. I am trying to find the state with the largest balance. The previous record won't work on a group summary, will it? Thanks

 

[lbass]

Create a formula like this and place it in the group section and suppress it:

whileprintingrecords;
numbervar maxbal;
stringvar state;
if sum({table.bal},{table.state}) > maxbal then (
maxbal := sum({table.bal},{table.state});
state := {table.state}
);

In the report footer, use a formula like this to display the result:

whileprintingrecords;
numbervar maxbal;
stringvar state;
state + ": "+totext(maxbal,2)//2 for two decimals

If your balance is a currency, change the numbervar to currencyvar in both formulas.

-LB

 

[Doris]

Thank you so much. That did it!