Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Formula Help Please

Status
Not open for further replies.

pomster

Technical User
Jan 15, 2003
88
AU
Using CR 10 I have a formula in GF2 that makes a calculation based on 2 variables, each from a seperate sub report. Everything works fine except I cannot for the life of me figure out how to sum this formula to place in the report footer.

Formula as follows:

WhilePrintingRecords;
Shared NumberVar CostValVar;
Shared NumberVar CreditVar;
NumberVar CallCostTotal;

CallCostTotal := (CostValVar-CreditVar)/{@VisitExWOS}


Help appreciated,

Regards,

David
 
Add the following two formulas to the report:

In GF2:
WhilePrintingRecords;
Numbervar MyTotal:=Mytotal+CallCostTotal

In the report footer:
WhilePrintingRecords;
Numbervar CallCostTotal;

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
 
I believe dgillz meant to say:

In the report footer:
WhilePrintingRecords;
Numbervar MyTotal;

An alternative would be to create a regular running total formula referencing the GF2 formula.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top