Link Remaining Duration and schedule percent complete

S
Shah. HB 👤 Member for 17 years 6 months

hi check this formula as Rafel stated in words



% completion =[Actual duration/total duration]*100

Actual duration =[Actual start-data date]

R
Rafael Davila 👤 Member for 22 years 3 months

Look on the thread named; Updating the schedule in P3.



More often than not the progress is not as planned, especially for a job showing a 9 months delay. When progress is not as planned, linking % complete and progress is wrong because of how formulas compute remaining durations using actual durations, instead of original duration once the activity is in progress and has some duration from a prior update period. Even if the software would calculate remaining duration as a function of Original Duration, not taking into account actual duration, the computations will in most cases be wrong.



Best regards,

Rafael

Forum Sponsor

Top Posters

Josephus Enot
1 posts
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