Sum of Null equals zero - How To Resolve

[nsm1234567]

Hey there,

I'm working on what should be a straightforward calculation, but I seem to be battling to get the behaviour I want.  If you look at the below, I'm doing a simple sum(NumberOfDays).  This is giving me a result of zero for Product A and Product D.  However, the Number of Days for Product D is actually null, and I want the calculation to return Null.  What is the best way to do this?  If I use a simple if statement, I have to do a sum of rows for the total, which I'd like to avoid.  Is there a straightforward way to return the result I want (app is attached).

[sunny_talwar]

Try this

=If(Count(NumberOfDays) > 0, Sum(NumberOfDays))

[woshua5550]

Firstly, in your case , it is actually a empty value rather then a null value , inline table can not produce null value

to prove this ,you can use "=NullCount(NumberOfDays)" , the result would be 0,

you can move your date into a Excel file which will produce null value

based on above , change your expression to like this

"=IF(NullCount(NumberOfDays)=0,Sum(NumberOfDays))"