on 08-17-2017 7:45 PM
Here is my situation: I have a list of work to be done for the day and for each of them there is a time associated if it's done. In the case that the work hasn't been done, I need to "fake" the future value by estimating what they are likely to be done by (by default, 15 minutes)
Here is what it looks like:
Work1 6:28.26
Work2 7:11.36
Work3 7:14.18
Work4 N/A
Work5 N/A
The estimated result for Work4 and Work5 should be respectively 7:29.18 and 7:44.18 and lighlighted in red to show that they are estimated and not actual value. I tried using
if isnull({Command.PackedTime}) then dateadd('n', +15, previous ({Command.PackedTime})) else {Command.PackedTime}
but it doesn't seem to work. Is there a way a can achieve this goal?
Hi Cyril,
Create a formula with this code:
shared datetimevar t;
if NOT isnull({Command.PackedTime}) OR {Command.PackedTime} <> datetime(0,0,0,0,0,0) then
t := {Command.PackedTime}
Else
(
t := dateadd('n', +15, t)
);
In the formula editor, look for a dropdown on the top that says 'Exceptions for Nulls', change that to 'Default Values for Nulls'.
Place the formula on the Details Section.
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
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.