B
bizee
I have data that includes hours per month by job category. In my
months table I also have a column that is the realized hours for each
month. (hours available less vacation or holiday days in that month).
I created a query that takes the hours each month by job category and
divides by the realized hours to get a full time equivalent
calculation.
That all works fine and provides an fte each month by job category.
now I wish to total that. I cannot simply total the row, as a 1 fte/
month would give 12 fte's in a year. Its really only 1 FTE. The
next best thing would be to average, but that doesn't get the right
data.
the best thing (say I want to run a report in November for Oct and Nov
data),is to sum the total hours charged by the total realized hours
for the 2 months only.
Not sure how to automatically do this. I guess I could add each
succcessive month realized hours in that table and sum that column. I
could create a report for each month ahead of time and then choose
that report (formulas built into the report ahead of time). or some
other method?
I also need help to figure out how to build this expression?
months table I also have a column that is the realized hours for each
month. (hours available less vacation or holiday days in that month).
I created a query that takes the hours each month by job category and
divides by the realized hours to get a full time equivalent
calculation.
That all works fine and provides an fte each month by job category.
now I wish to total that. I cannot simply total the row, as a 1 fte/
month would give 12 fte's in a year. Its really only 1 FTE. The
next best thing would be to average, but that doesn't get the right
data.
the best thing (say I want to run a report in November for Oct and Nov
data),is to sum the total hours charged by the total realized hours
for the 2 months only.
Not sure how to automatically do this. I guess I could add each
succcessive month realized hours in that table and sum that column. I
could create a report for each month ahead of time and then choose
that report (formulas built into the report ahead of time). or some
other method?
I also need help to figure out how to build this expression?