This topic contains 2 replies, has 2 voices, and was last updated by 
Larry Christofaro 2 weeks, 4 days ago.
- Posts
SashaHello! 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 olerI would think that in the absence of the data you mentioned (hours, cost, etc.) the %WorkComplete field would suffice, no?
Sasha, sorry I don’t have an answer for you that corrects your formula. have you tried just using the Physical % Complete field and manually updating your tasks…or maybe using that as an override for situations where you calculation doesn’t work (if Physical % complete exists, use that, else…)?
