Forum Discussion

Marius350's avatar
Marius350
Copper Contributor
May 03, 2023

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? 

  • Marius350 

    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's avatar
    Marius350
    Copper Contributor

    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.

    • John-project's avatar
      John-project
      Silver Contributor
      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
      • Marius350's avatar
        Marius350
        Copper Contributor

        John-project 

        Thank You so much for your explanation. Do you perhaps know of a formula I can use just for testing purposes? 

Resources