Forum Discussion
Solved
Help needed on MS Projects.
Hi Guys, Can you please assist me on the following. I cannot find the problem. On my MS Projects Schedule I have the following: % Planned and % Complete Now here is the thing. I ca...
Here is a sample plan with a group of milestones under a summary line. The Number1 field is customized with the formula shown. The summary line is set to sum up the number of completed milestones.
Hope this helps.
John
Marius350,
What exactly are you expecting to see for % Complete on the "Contract Milestones" summary line?
Percent complete for a summary line is calculated by the formula:
(sum of subtask actual durations)/(sum of subtask durations) * 100%
Since a milestone by definition has zero duration (it's just a point in time) the formula will always yield 0%, until, all milestones are 100%.
Apparently you have developed your own formula for % Planned. If you want some type of metric on how many milestones under the milestone summary line are complete, you will need to develop a custom formula for it.
Hope this helps.
John
What exactly are you expecting to see for % Complete on the "Contract Milestones" summary line?
Percent complete for a summary line is calculated by the formula:
(sum of subtask actual durations)/(sum of subtask durations) * 100%
Since a milestone by definition has zero duration (it's just a point in time) the formula will always yield 0%, until, all milestones are 100%.
Apparently you have developed your own formula for % Planned. If you want some type of metric on how many milestones under the milestone summary line are complete, you will need to develop a custom formula for it.
Hope this helps.
John
John-project
Thank You so much for your explanation. Do you perhaps know of a formula I can use just for testing purposes?