Need to show how many weeks someone didn't make productivity

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

Guest

I have a dbase with a listing of staff and their productivity for each week.
I've developed a report showing their expectation and their average
productivity.

Now I need to show how many of those weeks someone did NOT make
productivity. Can someone give me a formula for that?

Thank you!
 
Tina:

There's no per se formula you can create. If you have a target
productivity by say job class or time status (part time, full time etc.)
then put those targets into a table. Then link the person's job class or
time status in the query to these targets. Simple after that e.g.
IIF([Target]-[Actual]>0, True, False) will provide a -1 return value for
individuals that didn't meet the target which you can set as a check box or
some other flag on the report.
 
Back
Top