How do I AVERAGE and then SUM the Averages?

[jeromez]

I wrote a report which averaged by dept. the number of FTE (Full Time Equivalent or Headcount).

However, If a manager has more than one department I need to add or sum the average of those departments.

See attached file for an example.

Is there any way to do this?

Thanks!

Jerome

 

[boblarson]

You can't sum averages as it does not give an accurate picture.

The correct Avg for the entire thing is 7.33.

Who is wanting the 14.65 number? That is a totally inaccurate and irrelevant number statistically speaking.

 

[jeromez]

The correct Avg for the entire thing is 7.33.

You're right! I guess I've been looking at this too long =)

Thanks!

One more item:

I attached a screen shot of the query in Access that I use to run the report
(see file Qry_Pivot5.xls)

using the information in my query, is there any way to create the report so that the months go across the page?

Something like the picture in the attached file labeled "End_Result.xls