Hi, here is another problem from one of my Blog readers:
“Hi Nenad – allow me to give you an example of my problem. A task with a finish date of May 5/14 has a % complete of 25%. When the finish date is changed to May 30/14 the % complete automatically adjusts to 20%. I would like the finish date modification to be independent of the % complete. So when I change the finish date, the % complete does not change. Is there a way to change the relationship logic between finish date and % complete?”
I will show this relationship in MS PROJECT 2013! First I will Create brand new Project with only one Task:
and I will add % Complete field in the Gantt View:
Now I will mark Task as 25% Completed:
Finally, I will change Finish Date to May 30:
As you can see, Duration is now 23 days, and % Complete is 4%. Why?
Before changing Finish date, 25% of % Complete was actually 1 day because duration was 4 days and 25% is 4 * 25% = 1 day. SO actual duration was 1 day. Now the Finish Date is 30.04.2014, and Duration is 23 days. % Complete is calculated by formula: %Complete = Actual Duration / Duration = 1 day / 23 days = 0.0043478 = (rounded) 4%. You can see this here:
So, to conclude, When you enter %Complete for any Task, and you change Finish date, or Duration, %Complete is recalculated, and will not remain same as you entered. It is always calculated by formula mentioned above. This is the way how MS PROJECT works. If you want to keep %Complete same as before changing End Date, or duration you should simply enter this Value again in %Complete field.