give differnt wight to activity's

D
Doron El 👤 Member for 15 years 7 months

hello all
i need your help.
i need to give weight to each activity in the project.
for exmaple here are some activity's i'm dealing with:
1-purchase.=10%
2-Infrastructure installation=30%
3-instrument installation=40%
4-delivery=20%

for each activity i need to  take the percent of the activity that finished  and calculate a diffrent weight in  percentages

how can i do it without exporting the info to excel?

B
Bo Johnsen 👤 Member for 20 years 5 months

Maybe you can use this:

Introduce a Number1-column containing your percentages (i.e. 10, 30, 40 and 20). Introduce a Number2-column with a customized field containing the formula: [% complete] * [Number1]/100.

Maybe you also want to apply a rollup sum for summary groups for the Number2-column to get the overall completion % based on your weigthed percentages.

Hope this is what you were looking for.

 

Regards,

Bo 

Featured Partner

Top Posters

Zine Eddine
2 posts
Alex Lyaschenko
27 posts
mxsiegel
0 posts
Mattvtek
0 posts
Gareth Evans
3 posts
PP Admin
3, 129 posts
Rajkamal Tangirala
5 posts
Rahul Kumar
1 posts
blake333_
0 posts
Jeamiell Ostrovsky
2 posts