Doing Averages

[Bunky]

I have a rather complex report that is showing weekly data for an employee.
The report does a great job in grouping by month but I want to average some
on the fields showing on the report and it does this well unless the employee
did not work for one week (Vacation). Then it averages the totals shown over
the remaining 3 weeks over 4.

Example:

Employee A Weekly Data
Joe 95.00 (Wk1)
Joe 90.00 (Wk2)
Joe 0.00 (Wk3)
Joe 92.00 (Wk4)
Average 69.25 When I want it to be 92.33

How can this be accomplished?

Thanks for all of the help by you folks! You are worth a MILLION.

Kent

 

[Bunky]

Never Mind - Found the answer in an old post!

Thanks again!