How Can I calculate individual project effort in percentage from total

[arvindyadav]

Dear Team,

I need help regarding overall project effort in an individual employee in percentage.

eg.

suppose I have a person name Vijay and he is allocated to several projects like:-

Project name      Hours      percentage

Microsoft              10           10/36=0.27777778

Intel                        6           6/36=0.166666667

BNP                        8             8/36=0.22222222

TCS                         12         12/36=0.33333333

Total                     36                1

So as above I want all my employees' percentage in their respected projects in given time.

Regards,

Arvind

[Anonymous]

Hello,

How can you calculate the percentage when there is a large table with a mixture of employees, projects and tasks? 

So like:

Resource A - task 1 - 3 hrs

Resource B - task 2 - 3 hrs

Resource A - task 3 - 4 hrs

Resource B - task 3 - 2 hrs

Can you let the formula search for a specific Resource ID and calculate some other columns? Like Vlookup from Excel.

Appreciate any help

Best,

Fabian

[v-piga-msft · Accepted solution]

Hi @arvindyadav，

If I understand your requirement correctly that you want to calculate the percentage of each project that the empoyee has be allocated.

If it is, you could create a calculated column like below.

Percentage =
DIVIDE ( CALCULATE ( SUM ( 'Table1'[Hours] ) ), SUM ( 'Table1'[Hours] ) )

Then you will get the output.

If you need additional help please share some data sample and expected output.

Best Regards,

Cherry

[arvindyadav]

Hi @v-piga-msft,

Thanks.

[v-piga-msft]

Hi @arvindyadav,

I'm very glad that we can help. That's my pleasure!

Best Regards,

Cherry