Link Remaining Duration and schedule percent complete

S
Shah. HB 👤 Member for 17 years 7 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 4 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

Neil Atkinson
5 posts
Trian Asmoro
1 posts
Soheil Barekat
4 posts
Erkan Polater
9 posts
Luis Jr Ngade
6 posts
Ben Welsher
1 posts
Rohan Dashputre
0 posts
AMECHI ANAKWENZE
2 posts
Jayaprakash Sekar
1 posts
arash.karmand
0 posts