Forum Discussion
Help needed on MS Projects.
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
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?
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
John-project Thank You so much. I have tried the formula on myside but it still give me a syntax error. I also tried to retype it again but it still give me a syntax error.
Can you please assist?
I would help if you would post your formula. However, it may be as simple as changing the delimiter, which is a comma on my system, with a semicolon, which may be the delimiter on your system. For example, try this syntax:
IIf([Milestone]=True And [% complete]=100;1;0)
John