How can I get days overdue to stop revving without setting the value to null

Used what you suggested except Date Delivered is Actual Finish Date.

If(
[Status] = "Delivered"
and [Actual Finish Date] >=  ToDate([Calculated Finish Date]),
   ToDays([Actual Finish Date] - ToDate([Calculated Finish Date])),  

Max(0, ToDays(Today() - ToDate([Calculated Finish Date]))))

The line: ToDays([Actual Finish Date] - ToDate([Calculated Finish Date])),   give me the warning of �Expecting Duration but found number�

if you download the following app under sample app:  Dynamic Dashboard by Bill Marshall 24 May 17and look at any task that is marked overdue. I will used the ROI assessment task with the start date of 4-23-2015 for example:

This shows the task being 1458 days overdue.

If I change the status to Completed, the overdue date gets wiped out. (This was my original formula)

I would like to keep the # of days overdue so I can obtain metrics on how we did meeting deadlines.

I tried implementing the following formula which does not wipe out this value in days overdue, however the number of days keeps incrementing ever day.  How can I get the Days Overdue entry to stop incrementing once the status is marked completed?

If(ToDays(Today() - ToDate([Calculated Finish Date])) <= 0, null, Today() - ToDate([Calculated Finish Date]))

this is the results from my original formula

If([Status] = "Delivered", null, ToDays(Today() - ToDate([Calculated Finish Date])) <= 0, null, Today() - ToDate([Calculated Finish Date]))

• Initial task shows status �In Process� with days overdue being equal to 7
• If I set the status to delivered, the days overdue field becomes Null

When I add in your formula to Days Overdue (I get the warning I specified, but the formula does save)

If(
[Status] = "Delivered"
and [Actual Finish Date] >=  ToDate([Calculated Finish Date]),
   ToDays([Actual Finish Date] - ToDate([Calculated Finish Date])),  

Max(0, ToDays(Today() - ToDate([Calculated Finish Date]))))

• All Days Overdue turn to null
• If I set the status to Delivered, the Days Overdue is still null

I want to see days overdue for any status and once marked delivered, stop increasing the date