I am trying to create a report that shows the average of a users hours and then at the bottom shows the overall average of all users.
So if I have 10 users there will be an avg of hours worked for each user. Then at the bottom of the report I want to display what the avg is for all the users and hours worked.
SO
user 1 avg 10 hours
user 2 avg 15 hours
user 3 avg 12 hours
avg for all users 12.33
I created a report that has the avg hours for each user but when i try to do the total avg as =Avg([Avg of users]) i get #ERROR