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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Total a Formula 1

Status
Not open for further replies.

YANKRAY

Technical User
Nov 7, 2003
283
CR 10.0

I have the following formula at the Group 1 level.
There is only 1 group.

@COSTDEV
Maximum ({AQ_COST_TIER.COST}, {PH_WORKSHEET.SEQ_NO}) * {PH_WORKSHEET.COUNT_DEV}

How do I create a total in the Report Footer?

Thanks,
Ray
 
Create a formula to total {@COSTDEV}

Place this in the group footer section - suppressed

Code:
//@GrandTotal
WhilePrintingRecords;(Shared NumberVar MyTotal := MyTotal + {@COSTDEV};

MyTotal

Create a 2nd formula to display the results in the Report footer section

Code:
//@Display
WhilePrintingRecords;
Shared NumberVar MyTotal;

HTH


Gary Parker
MIS Data Analyst
Manchester, England
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top