cancel
Showing results for 
Search instead for 
Did you mean: 

Help with date formula in running totals

Former Member
0 Kudos

Hello,

I am trying to generate a Running Total where the number of units is only counted if the job completion date exceeds the due date by 30 days.

There are also times when the completion date is null because the job has not yet been completed.

Any help would be appreciated.

Thank you.

Helen

Accepted Solutions (1)

Accepted Solutions (1)

DellSC
Active Contributor
0 Kudos

Set up your running total and use something like the following formula to define when it will be evaluated:

(IsNull({completion date field} and {due date field} + 30 < CurrentDate)

OR

(({due date field} + 30) < {completion date field})

-Dell

Answers (1)

Answers (1)

Former Member
0 Kudos

Thank you Dell!