How do I get a grand total for a field with a maximum formula? 1

[suefhmis]

Hi, I'm using CR 8.5 Developer Edition. I'm using the following formula ("Balance&quot in the Group #2 Footer:

Maximum ({query.balance_due}, {query.sales_contract_nbr})

All I want to do is get a grand total of the formulated field. Is this possible? If so, how? Thanks!

 

[pgtek]

hi

in your insert table on the tool bar
click on insert -> grand total

cheers

pgtek

 

[suefhmis]

I tried to do that. Unfortunately, my formulated field, @Balance, isn't listed as one of the fields for which you can insert a grand total.

 

[pgtek]

hi
try
@GrandTotal

Sum({@Balance})

 

[suefhmis]

I get a "The summary / running toal field could not be created" message.

 

[mbarron]

You can do this using a 3 formula running total

In the report header and footer (put a copy of the formula in each spot (or create two formulas):
whileprintingrecords;
numbervar addit;

for the GF2;
whileprintingrecords;
numbervar addit:=addit + Maximum ({query.balance_due}, {query.sales_contract_nbr});

Suppress the formula kields in the GF2 and the report header.



Mike

 

[synapsevampire]

Use the 3 formula approach to demonstrate producing totals at the Group 1 level:

Group 1 header:
whileprintingrecords;
numbervar MaxBalDue :=0;

Group 2 Footer:
whileprintingrecords;
numbervar MaxBalDue;
MaxBalDue := MaxBalDue+Maximum ({query.balance_due}, {query.sales_contract_nbr});

Group 1 Footer: // displayed here
whileprintingrecords;
numbervar MaxBalDue

You can alter this to provide a grand total by omitting the GH1 formula and placing the GF1 formula in the report footer.

-k

 

[suefhmis]

Hi Mike,

I tried it...not sure I did it correctly. I created the following TWO formulas:
"Def Variable" = whileprintingrecords;
numbervar addit;

"GF2" = whileprintingrecords;
numbervar addit:=addit + Maximum({query.balance_due}, {query.sales_contract_nbr});

I put both formulas into the report header and footer and put the GF2 formula into GF2. However, the total of numbervar addit is off by the amount of the very first balance due...did I put something in the wrong place? Or did I skip a step?

 

[mbarron]

add this to the beginning of the gf2 formula

evaluateafter({@balance});

Mike

 

[lbass]

You need to remove the GF2 formula from the report footer. This is causing the last value to increment again. Only use the display formula in the report footer:

whileprintingrecords;
numbervar addit;

I think you only need the GF formula in the GF2 and the display formula in the report footer. You don't need to set or reset if your total is for the report as a whole and not at the group level.

-LB

 

[suefhmis]

synapsevampire,

I bow to you, CR genius. It worked perfectly. Thanks so much.

-s