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.
MCFNeil's avatar
MCFNeil
Qrew Captain
8 years ago
If([Contract Down Time]<=0,   ....

Or do they put 0 and you want that to be true if they put 0?