replace null with zero with sum

ajater2012 — Tue, 05 May 2020 09:33:41 GMT

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.

Re: replace null with zero with sum

agigliotti — Tue, 05 May 2020 09:45:34 GMT

maybe this:

=Sum( if( IsNull(v1), 0, v1 ) )
+
Sum( if( IsNull(v2), 0, v2 ) )

I hope it can helps.