Show correct %-Allocation in Resource Usage for a specific project when using Resource Pool
I would like to get Percent Allocation in Resource Usage, by a specific project when I have a pool of resources and a master project using two simple projects (testP1, testP2) like the following to illustrate the point. I have the following:
And I would like to visualize the monthly percent allocation in the Resource Usage view. Considering Sept,2025 which has 168 working hours.
I created the following custom group: Group by Projects as follows, to group by project, so I can have the information I am looking for:
Note: I followed the answer from Ignacio Marin for this question: MS Project Resource Pool Usage. Then I followed the instructions from this post: View resource workloads and availability in Project desktop to add Percent Allocation in the Detail column of the Resource Usage view.
Now using this custom group I would like to get the calculation for %-Allocation for project testP1, so I filter the Project column to select just this project. I am getting the following results:
As you can see the result is as expected for Work, but not for % Allocation. For example for Res1 is working 80 hours, so its allocation should be: 80/168=48%, but the allocation cell is empty for Res1. If it is a single task, as it is for Res2, then the %-Allocation is correct: 40/168=24%. Why it is not possible to calculate the %-Allocation for Res1?
What I am doing wrong here? Is there a way to get the %-Allocation per project when using a pool of resources?
I would like to get Percent Allocation in Resource Usage, by a specific project when I have a pool of resources and a master project using two simple projects (testP1, testP2) like the following to illustrate the point. I have the following: And I would like to visualize the monthly percent allocation in the Resource Usage view. Considering Sept,2025 which has 168 working hours. I created the following custom group: Group by Projects as follows, to group by project, so I can have the information I am looking for:Note: I followed the answer from Ignacio Marin for this question: MS Project Resource Pool Usage. Then I followed the instructions from this post: View resource workloads and availability in Project desktop to add Percent Allocation in the Detail column of the Resource Usage view. Now using this custom group I would like to get the calculation for %-Allocation for project testP1, so I filter the Project column to select just this project. I am getting the following results: As you can see the result is as expected for Work, but not for % Allocation. For example for Res1 is working 80 hours, so its allocation should be: 80/168=48%, but the allocation cell is empty for Res1. If it is a single task, as it is for Res2, then the %-Allocation is correct: 40/168=24%. Why it is not possible to calculate the %-Allocation for Res1? What I am doing wrong here? Is there a way to get the %-Allocation per project when using a pool of resources? Read More