Average expression in a Reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a crosstab query that gave me a count of items in a specific
catergory by month. The last column gives me the total sum of items for each
category. I also needed the average of the total sum for each category.
When I use the formula Avg([Total]) it returns the results for Average of the
Grand Total. I am missing something in the expession. But, I cannot figure
out what it is.
 
Accessuser,

Do you mean the monthly average? The Avg() function will not work like
this. I am not sure what [Total] refers to in your example. But I
think you will need to get a count of the number of months covered by
your query, and then do a calculation something along these lines:
[TotalForEachCategory]/[NumberOfMonths]
 
Back
Top