Forum Discussion

PriscillaFramar's avatar
PriscillaFramar
Qrew Trainee
6 years ago

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

I am currently using the following formula which captures the days overdue within the formula field ?Days Overdue? while the status is not equal to Delivered.  I would like to be able to set the s...
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
Can you post your formula and the complete error message?
PriscillaFramar's avatar
PriscillaFramar
Qrew Trainee
6 years ago
the formula is saved.  the days overdue value is wiped out. 
here is a clean scenario on a app that you could walk through to see what I am referring to:

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]))