Forum Discussion
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 can only get a value % after I put in a number of days, but I do not want to do that as it is a milestone. The day must stay 0. If I make the number of days 0 then I do not get a % value, How do I change that again, please?
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
As per attachment. You will see the parts that is marked yellow. On the % Planned it give me a value but on % Complete it do not give me a value. As per my previous question, if you add days to the milestones then the % complete is correct but as I mentioned it is a milestone and I cannot add days.
- 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.
JohnJohn-project
Thank You so much for your explanation. Do you perhaps know of a formula I can use just for testing purposes?
