give differnt wight to activity's

D
Doron El 👤 Member for 15 years 5 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 3 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 

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts