Actual Available Hours column should deduct the all vacations of resources

Actual Hours column should deduct the all vacations of resource and should provide only the real available hours for that resource, which will help the resource managers to know the actual capacity available during that period and plan for work only for real available hours

Premnath

7 Posts
0 Reply Likes

Posted 4 years ago

4 years ago

Lingaraj Dharwad, Product Champion

1100 Posts
46 Reply Likes

Hi Premnath,

Thank you for using Replicon community.

Actual Hours are currently calculated only for the time entered against projects. Are you referring to Actual Available Hours instead?

Regards,
Lingaraj

Comment

4 years ago

Premnath

7 Posts
0 Reply Likes

Hi Lingaraj,

yes i was referring to the Actual Available hours, it should be simple math if i got it correctly, number of hours for that month based on location - Time Off hours

Thanks & Regards,
Prem

Comment

4 years ago

Lingaraj Dharwad, Product Champion

1100 Posts
46 Reply Likes

Hi Premnath,

In the Resource template report type which contains the column Timeoff taken Hours (Selected Dates). This can be used to create a custom column with formula ActualAvailableHours-ActualTimeOffTakenHours. This should give you what you're looking for.

Refer to the image below:

Image: https://d2r1vs3d9006ap.cloudfront.net/s3_images/1226047/14194-1y7h3qw_inline.png?1435157861

Image: https://d2r1vs3d9006ap.cloudfront.net/s3_images/1226047/14194-1y7h3qw_inline.png?1435157861

Let me know if that helps.

Regards,
Lingaraj

Comment

4 years ago

Premnath

7 Posts
0 Reply Likes

Hi Lingaraj,

Thats what i tried the issue is Stat holidays is taken count in both the fields which is causing the mismatch in numbers, i mean if we have the stat holiday for a month, Actual Available hours will deduct that and Time Off field also counts that.

Thanks & Regards,
Prem