# MS Project 2016. Real progress of the project, % complete

Home Forums Discussion MS Project 2016. Real progress of the project, % complete

Viewing 3 posts - 1 through 3 (of 3 total)
• Author
Posts
Sasha
Guest

Hello! Is there a formula or some way to calculate the real progress of the project in %? Unfortunately, there are no resources, no money, no time spent, only tasks with their duration, start, finish, baseline and % completion. Tried through the formula of the planned % completion:

Round(IIf([Milestone],IIf([Start]>=[Status Date],0,100),IIf([Start]>=[Status Date],0,IIf(ProjDateDiff([Finish],[Status Date],[Project Calendar])>0,100,ProjDateDiff([Start],[Status Date],[Project Calendar])/[Duration]*100)))) & “%”

﻿But it does not reflect reality, it is simply tied to the status date, and if we increase the % of completion as, for example, ahead of the plan, the indicator does not change. We also tried another method, created 2 numerical fields, one assigned the values of the formula IIf([% Complete]=100,1,0)﻿, the second one – ﻿IIf([Milestone],0,1)﻿ then calculated by formula: ﻿IIf([Summary],Format([Number1]/[Number2],”###%”),” “) , ﻿but still the calculations are not quite accurate, besides, with the increase in the percentage of completion tasks, the formula calculates 104% for some tasks. Are there other methods for calculating the real progress of the project? Thank you!

robert oler
Guest

I would think that in the absence of the data you mentioned (hours, cost, etc.) the %WorkComplete field would suffice, no?