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

Calculating % in group subtotal?

Status
Not open for further replies.

nshefler

Technical User
Jan 25, 2002
2
I am having trouble calculating the percentage on the group subtotal as a percent of the grand total.

Example

REPORT XYZ
YTD Volume % of total YTD Volume
Line 1 100 10%
Line 2 300 30%
Subtotal 400 (How do I get this)
...
...
...
Grand total 1000 100%

Formula for the grand total in the report text box (in the Report Footer) is =Sum([YTD Volume])/Sum([YTD Volume])

Formula for the Lines (the Detail section) with in the groups is =[YTD Volume]/sum([YTD Volume])

I can't get the Group Subtotal lines (in the Group Footer) to calculate the correct %.

Please help, thanks.
NS

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top