Planned percent complete calculation in MPP
Create a Text field. Apply the following formula to calculate Planned % Complete:
str(IIf([Status Date]<[Start],"0",IIf([Status Date]>[Finish],"1",ProjDateDiff([Start],[Status Date])/[Duration]))*100)+"%"
Note: Above formula may not work properly at summary task level.
str(IIf([Status Date]<[Start],"0",IIf([Status Date]>[Finish],"1",ProjDateDiff([Start],[Status Date])/[Duration]))*100)+"%"
Note: Above formula may not work properly at summary task level.
Labels: MS Project - Planning
posted by Satyanarayana DLV @ 10:49 AM
1 Comments:
At Thursday, January 17, 2019 11:44:00 AM ,
saad said...
This is a great inspiring article.I am pretty much pleased with your good work.You put really very helpful information. Keep it up. Keep blogging. Looking to reading your next post. aliquota imu genova
Post a Comment
Subscribe to Post Comments [Atom]
<< Home