Forum Discussion

AndreonnaGarret's avatar
AndreonnaGarret
Qrew Assistant Captain
8 years ago

Status field for a duration not working properly

I have a duration field called [Contract Down Time]. I would like to put a status on this that would return "Downtime Reported" if there is a value in the field, and "No Downtime" if the field was lef...
MCFNeil's avatar
MCFNeil
Qrew Captain
8 years ago
Try to use the IsNull function rather than the <>"".

If(IsNull([Contract Down Time]),

If the field properties for the duration field have "treat blank values as '0' in calculations" it will cause your <>"" to have the value of 0, so its not ever blank.
AndreonnaGarret's avatar
AndreonnaGarret
Qrew Assistant Captain
8 years ago
This is what I originally tried. I couldn't do that because the status field is text and the [Contract Down Time] field is a duration.