locked
MS Project Professional 2010: Calculate Remaining Duration After entering Actuals ? RRS feed

  • Question

  • Hello,

    I hope this is a Project Professional Frrum question (though my environment is really Project Server 2010 with Project Professional 2010)

    After updating Actuals in my project in Project Professional 2010 , Remaining Duration of one of the delayed tasks which has not started on the Status Date is 63 days. Project Professional 2010 has calculated the new Start and Finish Days correctly as expected. However  Remaining Duration for Project is 41 days. This seems to be calculated at Project Summary Level from the % complete and Duration of the project . Is this an expected behaviour ? Logically I would expect the remaining duration of a project to be rolled up as maximum value of the remaining duration of the project tasks as the project cannot complete until all its tasks are complete.

    If I want  Remaining Duration of my project to reflect the maximum of remaining duration of all project tasks, is there any configuration settings or fields that can get me this result

    or

    Do I need to define an enterprise custom Task field in Project Server with Roll up set to maximum ?

    Any other suggestions ?

    Thanks


    MathurP
    Thursday, June 23, 2011 3:02 AM

Answers

  • Hi,

    First, my previous reply provides an answer.

    Also, the formula ProjDateDiff([Status Date],[Project Finish])is an answer as well.

    Greetings

    • Marked as answer by MathurP Thursday, June 23, 2011 9:42 AM
    Thursday, June 23, 2011 9:19 AM

All replies

  • Hi,

    Remaining Duration is Duration - Actual Duration. It can't rolled up the maximum of the remaining duration as there are various variables, dependencies etc driving the Duration.


    Sapna S
    Thursday, June 23, 2011 6:19 AM
  • Hi,

    Let me focus on the second part of your question - can I show the maximum ...

    Yes you need a custom (duration) field for that. Simple formula is [Remaining Duration] with rollup as Maximum.

    Greetings,


    Thursday, June 23, 2011 7:53 AM
  • Hi Sapna, 

    So how do I compute the 'real' remaining duration? If a Project Manager wants  to know in how many days (from the Status Date) will the project complete, the Project Remaining Duration field gives a wrong picture as some of the Tasks on the Project have Remaining Duration greater than the Project Remaining Duration.

    Thanks


    MathurP
    Thursday, June 23, 2011 7:58 AM
  • Hi,

    First, my previous reply provides an answer.

    Also, the formula ProjDateDiff([Status Date],[Project Finish])is an answer as well.

    Greetings

    • Marked as answer by MathurP Thursday, June 23, 2011 9:42 AM
    Thursday, June 23, 2011 9:19 AM
  • Hi,

    Were the entire project updated as to shift after status date or selective tasks. Please refer to following links to see if you are doing it right or missing something : http://office.microsoft.com/en-us/project-help/update-the-percentage-that-a-task-is-complete-HP045319888.aspx

    http://office.microsoft.com/en-us/project-help/remaining-duration-task-field-HP045305278.aspx

     


    Sapna S
    Thursday, June 23, 2011 9:41 AM
  • Hi Jan,

    ProjDateDiff([Status Date],[Project Finish]) works fine. Should have thought of this myself.

    Thanks a ton !


    MathurP
    Thursday, June 23, 2011 9:42 AM