replace null with zero with sum

[ajater2012]

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.

[agigliotti · Accepted solution]

maybe this:

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

I hope it can helps.