# Clarity PPM

## Calculation of % Days Late

• #### 1.  Calculation of % Days Late

Posted 10-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 10-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 10-02-2018 10:15 PM

Thank you Urmas,

Regards,

Cira

• #### 4.  Re: Calculation of % Days Late

Posted 10-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 10-08-2018 01:23 PM

• #### 6.  Re: Calculation of % Days Late

Posted 10-08-2018 01:30 PM

• #### 7.  Re: Calculation of % Days Late

Posted 10-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. * '

Regards,

Cira

• #### 8.  Re: Calculation of % Days Late

Posted 10-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.