Clarity

  • 1.  Calculation of % Days Late

    Posted Oct 02, 2018 10:14 AM

    Hi,

     

    Somebody knows how %days late are calculate in  tasks in Project dashboard  portlet ?

     

    Regards,

     

    Cira



  • 2.  Re: Calculation of % Days Late

    Posted Oct 02, 2018 01:12 PM

    Something like

     

        * If the record is a summary task (prIsTask = 0), use the summary task's dates in the denominator.                                               *
        * If the record is a detail task (prIsTask = 1) and it's at the top level (prWBSLevel = 1), use the project's dates in the denominator.          *
        * If the record is a detail task (prIsTask = 1) and it's not at the top level (prWBSLevel > 1), use the summary task's dates in the denominator. *
        *                                                                                                                                                *
        * Schedule % (stoplight) and Days Late % (value):                                                                                                *
        * If there is a Baseline and Finish Date is not equal to Baseline Finish Date, then ((Finish Date – Baseline Finish Date) /                      *
        * (Baseline Finish Date – Baseline Start Date)) * 100 (This calculates days late % positive or negative based on baseline).                      *
        *                                                                                                                                                *
        * If there is a Baseline and Finish Date equals Baseline Finish Date and Project Progress (or Task Status) is not completed                      *
        * and the Finish Date is before Today’s Date, then ((Today’s Date – Finish Date)/(Baseline Finish Date – Baseline Start Date)) * 100             *
        * (This calculates days late % positive if the project/task isn’t late according to the baseline, but it isn’t completed and it is               *
        * has a finish date before today’s date).                                                                                                        *
        *                                                                                                                                                *
        * If there is no Baseline and Project Progress (or Task Status) is not completed and the Finish Date is before Today’s Date,                     *
        * then ((Today’s Date – Finish Date)/(Finish Date – Start Date)) * 100  (This calculates days late % positive if there is not any                *
        * baseline and the project/task isn’t completed and it is has a finish date before today’s date).                                                *
       



  • 3.  Re: Calculation of % Days Late

    Posted Oct 02, 2018 10:15 PM

    Thank you Urmas,

     

    Regards,

     

    Cira



  • 4.  Re: Calculation of % Days Late

    Posted Oct 08, 2018 11:52 AM

    Someone knows what is the theoretical basis that governs the % Days Late algorithm?

     

    Regards,

     

    Cira



  • 5.  Re: Calculation of % Days Late

    Posted Oct 08, 2018 01:23 PM

    Searching gives an earlier thread

    What is Days Late. what does it represents? 



  • 6.  Re: Calculation of % Days Late



  • 7.  Re: Calculation of % Days Late

    Posted Oct 08, 2018 02:49 PM

    Thank you Urmas, 

     

    I have some doubts abouts thist paragraph

     

    '* If the record is a summary task (prIsTask = 0), use the summary task's dates in the denominator.                                               *
        * If the record is a detail task (prIsTask = 1) and it's at the top level (prWBSLevel = 1), use the project's dates in the denominator.          *
        * If the record is a detail task (prIsTask = 1) and it's not at the top level (prWBSLevel > 1), use the summary task's dates in the denominator. * '

     

     

    Why the formula use the summary task's dates  in the denominator instead of  task's dates

     

    Regards,

    Cira



  • 8.  Re: Calculation of % Days Late

    Posted Oct 08, 2018 03:08 PM

    I just copied the URL's and really do not know the thinking behind the applied logic.

    On the other hand I do agree with you that the 2nd. and 3rd options do not sound very good for calculating the value for a detail task.