I'm trying to write a calculation that would show nulls or 0 as false
This is what I have but it is not working:
if
SUM([ActualHours])
> 7.9999
then True Else False OR
sum([ActualHours]) = NULL
False
END
Thoughts?
Hello Josi,
Not able to open your workbook:
You can try below logic:
if SUM([ActualHours]) > 1000 OR ISNULL(SUM([ActualHours]))
then True Else False
Retrieving data ...