I'm trying to figure out a formula to calculate average productivity per day and nothing I do seems to work.
I have a table with call reviews. Not every person who completes reviews works every single day of the month. I would like to determine their average daily productivity by taking the number of reviews they complete per month and dividing that by the number of days they actually worked.
I can't seem to get the piece for the number of days that have productivity.
I could use either the Monitor Stop Date/Time field or the Date Created field to establish the days that have reviews completed.
Any assistance is greatly appreciated.
Thanks,
------------------------------
Sheila Allas
------------------------------