Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a simple question, I added to sum values and some of the result are null and I want to replace null with zero,
I tried this code but it shows all values as null:
If(IsNull(Sum(v1) + sum(v2)), 0)
any help will be appreciated.
maybe this:
=Sum( if( IsNull(v1), 0, v1 ) )
+
Sum( if( IsNull(v2), 0, v2 ) )
I hope it can helps.
maybe this:
=Sum( if( IsNull(v1), 0, v1 ) )
+
Sum( if( IsNull(v2), 0, v2 ) )
I hope it can helps.