How to summarize formula, which has a running total?

[something99]

There are three groups in the report. And I do not know how to get sbtotals and a grand total for a formula containing a running total.
The formula is:
{#RTotal0}/{@ffectiveRate} where
#RTotal0 is a coditional running total reset on a group change;
@ffectiveRate is a formula, which returns a NumerVar WhilePrintingRecords.
I am using Crystal 8.5

 

[Ngolem]

try this

In the report header place this formula

****************

//@InitializeGrandTotal

WhilePrintingRecords;
NumberVar GrandTotal := 0;

****************

In the Group header place this formula

****************

//@InitializeSubTotal

WhilePrintingRecords;

if not inRepeatedGroupHeader then
NumberVar Subtotal := 0;

****************

Where the current formula - {#RTotal0}/{@ffectiveRate} - is being calculated change it to the following

****************

//@NewDetail

WhilePrintingRecords;
NumberVar Subtotal;
NumberVar Grandtotal;
NumberVar Total;

if {@ffectiveRate} <> 0 then
Total := {#RTotal0}/{@ffectiveRate}
else
Total := 0;

Subtotal := Subtotal + Total;
Grandtotal := Grandtotal + Total;

Total;

****************

Now place the display for the subTotal and GrandTotal where they belong

****************

//@DisplaySubTotal

WhilePrintingRecords;
NumberVar Subtotal;

Subtotal;

****************

//@DisplayGrandTotal

WhilePrintingRecords;
NumberVar Grandtotal;

Grandtotal;


****************

This should work for you


Jim Broadbent

 

[something99]

Hi Jim,
This did not work for me. But I am not sure I know how to reply to you.
Regards