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