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

percantage of Subtotals according to Grand total

Status
Not open for further replies.

cuneyt

Programmer
Mar 3, 2003
42
AU
How can I take percantage of Subtotals according to Grand total...

Example: That's what I want

Group Footer1: Sum of Ado.Duration = XXX 30 30%
Sum of Ado.Duration = YYY 50 50%
Sum of Ado.Duration = ZZZ 10 10%

Group Footer2: Sum of Ado.Duration = Total 100

Thanx
Cuneyt
 
ooops ok, that was a stupid easy question,

but anyways if someone needs,
here is the answer:
go and create a new formula, write this:

Sum({ado.yourfield}, {ado.yourfiled}) % Sum({ado.yourfiled})

Put it next to your group where your subtotals are....
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top