Average Productivity

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I have a subform that is used to enter payroll information
such as HoursWorked, PiecesProduced and JobCode. There is
also a field that calcs the Productivity as a percentage.
In the footer of the form I added a text boxes to subtotal
Hours and Pay and it workes fine. But I find that when I
add a text box in the footer to average the percentage, it
doesn't work.

What I need is to show a workers totals for HoursWorked,
Pay and Total Productivity as an average percentage.

I hope that's enough info.
thanks!
 
Thanks for responding Tina,
I actually used this formula in a query to get the
Productivity in percentage:
txtPercent: Format([Pay]/[WageBase]/[Hours],"Percent")

This gives me a worker's Productivity per job. What I was
looking for was a worker's Average Productivity for all
jobs a worker has done. So, if in one day a worker did
let's say 4 different jobs and his productivity for each
job was: 87%, 63%, 50% and 25%
His Average Productivity would be: 56%

Any ideas?
 
i'm assuming that the subform shows info for only one
worker at a time? if so, and if you already know the
formula to get the percent of productivity that you want
for each record, then:

1. create an unbound textbox in the subform's footer.
2. enter the formula.
3. change it to sum the values for all records. don't sum
the percentage field itself, do the formula on the sums of
the "raw" number fields.

you'll have to figure the math out. i'm not sure what
WageBase is; if it's pay-per-hour, seems like Pay/Hours
gives you WageBase....so i'm afraid i don't understand
your formula. perhaps

Sum(Pay/WageBase)/Sum(Hours)

would work?

good luck. maybe some "mathie" out there can help?

-----Original Message-----
Thanks for responding Tina,
I actually used this formula in a query to get the
Productivity in percentage:
txtPercent: Format([Pay]/[WageBase]/[Hours],"Percent")

This gives me a worker's Productivity per job. What I was
looking for was a worker's Average Productivity for all
jobs a worker has done. So, if in one day a worker did
let's say 4 different jobs and his productivity for each
job was: 87%, 63%, 50% and 25%
His Average Productivity would be: 56%

Any ideas?
-----Original Message-----
you didn't post the expression you're using....maybe you
haven't tried this:

=Sum(HoursWorked)/Sum(PiecesProduced)


.
Click to expand...
.
Click to expand...
 
Back
Top