Column Calculations 101

J

Julius

I have a report in which I am inputting monthly averages from Jan-Dec,
manually using a form. The code below is what I used to have the averages per
month show up on the report. I have a totals column, how do I get an average
of the average for the totals.

=Sum(IIf([QualityMonthID]=1,[QualityVisionAvg],0))
 
K

KARL DEWEY

Mathematically you can not do it.
Average 50, 50, & 50 = 50. Average 10, 100, 50, 50, and 75 = 57

Average 50 & 57 = 53.5
Average 50, 50, & 50, 10, 100, 50, 50, and 75 = 54.375
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Avereging the Subtotals in Reports 1
Sum if 1
Access Report Average Miles/Gallon in Group Footer and Report Footer? 9
Random month column 5
Report Totals 3
Sum group totals and then average by # of groups 2
Summary Functions taking too long and Dynamic Chang of Detail Field Backgrounds 2
Weighted Calculations 7

Top