on 09-27-2016 8:21 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you Dell!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.