Calculated Field that averages another field

  • Thread starter Thread starter www.ttdown.com
  • Start date Start date
W

www.ttdown.com

I have a field named [Hours] in a report that returns the number of
hours a person has worked for a time period. The report returns a
line for each staff person with the staff's name. I'd like to add a
calculated field that would return the average of all the hours that
all staff have worked for the period. Something like Sum of
Hours/Number of Staff. Could anyone tell me how to do this? - Thanks
 
www.ttdown.com said:
I have a field named [Hours] in a report that returns the number of
hours a person has worked for a time period. The report returns a
line for each staff person with the staff's name. I'd like to add a
calculated field that would return the average of all the hours that
all staff have worked for the period. Something like Sum of
Hours/Number of Staff. Could anyone tell me how to do this? - Thanks
Click to expand...


In the report footer, use a text box with an expression.
From your description, I think you can simply use
=Avg(Hours)
 
Back
Top