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

Average a sum 1

Status
Not open for further replies.

pungigis

Programmer
Dec 5, 2007
71
US
Is there a way to average a sum at a group level???

Ok, I have 12 weeks worth of data grouped to a weekly count I also need to get an average of the whole twelve weeks and compare that to the last week of data.

So currently I see this...

Grouped on date printed for each week

8/8/2010 129 6 4.65%

8/1/2010 233 4 1.72%
7/25/2010 051 2 3.92%
7/18/2010 069 3 4.35%
7/11/2010 092 4 4.35%
7/4/2010 139 2 1.44%
6/27/2010 190 5 2.63%
6/20/2010 128 3 2.34%
6/13/2010 163 5 3.07%
6/6/2010 167 4 2.40%
5/30/2010 083 2 2.41%
5/23/2010 140 50 35.71%
5/16/2010 111 1 0.90%

I need to see this...

8/8/2010 129 6 4.65%
12 Wk Avg 126 7 5.37%

8/1/2010 233 4 1.72%
7/25/2010 051 2 3.92%
7/18/2010 069 3 4.35%
7/11/2010 092 4 4.35%
7/4/2010 139 2 1.44%
6/27/2010 190 5 2.63%
6/20/2010 128 3 2.34%
6/13/2010 163 5 3.07%
6/6/2010 167 4 2.40%
5/30/2010 083 2 2.41%
5/23/2010 140 50 35.71%
5/16/2010 111 1 0.90%

Can I even do what I want, can I get a "avg total" at a group level????
 
If you reverse the week order, you can do it using a variable, and accumulating and counting the percents and then calculating the average in a display formula in the report footer.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top