Column Calculations 101

  • Thread starter Thread starter Julius
  • Start date Start date
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))
 
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
 
Back
Top