Skip to Content
0
Former Member
Mar 04, 2009 at 05:31 AM

Logic to calculate average number of employees per day...

1889 Views

Hi,

In an internal table, i have employee number, start date, end date.

This table shows employee's start and end dates for a cost center.

Now, the requirement is to calculate the average number of employees available per day for a given period...

Lets asume that we would like to calculate average number of employees per day for a given period of 30 days (01.01..2009 to 30.01.2009)....

The above table will have around 20 employees with their start and end date.

Among these 20, some may be present between 1st to 10th Jan only..

In such case, How to calculate average number of employees per day in such case?

Can anyone help me out with a rough sketch of logic for this calculation?

Thanks in Advance,

Pavan