Why are my percentages not calculating correctly when this is set at the project level?

Deanna C
Deanna C
edited 03/18/24 in Formulas and Functions

My parent/child percentages are not calculating correctly. Why is NP showing more complete than the other two departments when they are clearly behind?


Answers

  • John_Foster
    John_Foster ✭✭✭✭✭✭
    edited 03/15/24

    HI @Deanna C,

    This will be most likely to do with the number of days assigned to tasks. The days a task takes is weighted and without seeing the tasks within each of the phases of each section it is hard to determine the exact cause.

    Are you able to expand the phases? and screenshot it to help determine exactly what the cause may be or does this answer the question?

    John

  • John_Foster
    John_Foster ✭✭✭✭✭✭

    Hi @Deanna C,

    Also just a note, do you realise that the start and end dates seem to be set the wrong way round in the Project Settings?

    John

  • @John_Foster - Please see expanded below. I'll post again and show you what happens to the project finish % if I change it to start date to end date. Also, all the start & end dates for each department are the same.


  • Above is with the Start/end date changed

    Below is the current settings with End/Start:


  • John_Foster
    John_Foster ✭✭✭✭✭✭

    Hi @Deanna C,

    As expected the number of days within each phase is the cause for it.

    In Phase 3 the tasks total 98 days as shown below and based on the % completion 66 days have been completed or 67%.

    In Phase 4 the tasks total 83 days as shown below and based on the % completion 55 days have been completed or 66%.

    I hope this helps make sense of this for you.

    John

  • How do I correct this? Because they all have the same start/finish dates. and I'm REALLY sorry, but i'm not understanding what you are saying.

  • John_Foster
    John_Foster ✭✭✭✭✭✭

    Hi @Deanna C,

    There is nothing to correct the calculations are correct based on their weighting. The only way to amend this to show the way that you want is for the dates on the items within each phase to make sure that the total number of days of all the lowest level indented rows match for each section.

    Looking at the post on 18th March, while Phase 3 spans 11 days there are 19 days of work within that phase, whereas Phase 4 has 25 days of work. This will most likely be the same across the different department levels as well.

    The rolled-up % completion is based on the number of days within the whole indented section that is considered complete, the comparison you are making is not a like-for-like comparison.

    John

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!