Adding a New Column to Straight table

[niharika1234]

Hello,

I want to add a new column showing days late for particular Task. For example the first task 10059 should show days late which is (02/28/20130- 03/08/2018)= 10 days around . But the expression show 1 days. The expression is count(TASK_CLOSED_DATE-TASK_DUE_DATE). Please suggest.

[Gysbert_Wassenaar]

Try using the sum function instead of the count function. Count merely counts if task_closed_date - task_due_date returns a result or not.

[niharika1234]

Thanks. It is working but minor error.

[niharika1234]

Thanks. It is working but minor error. Looks like it is counting hour as well. The Closed date and Due Date are on same date but showing Number days late as  -1. . Also the second one should be 2 days. Please suggest.

[Gysbert_Wassenaar · Accepted solution]

Try sum(Floor(TASK_CLOSED_DATE)-Floor(TASK_DUE_DATE))

[niharika1234 · Accepted solution]

Thanks. It is working now.