How to sum null values ?

[vivientexier]

How do I sum different fields even if some of them are "null" ?

When I do it something like these :

45 + "Null value" + 75 I get "Null value" but I want 120.

[ecahen · Accepted solution]

Hi Vivien,

You should not sum with the "+" sign. Use the "RangeSum()" function.

Try RangeSum(45, "Null Value", 75), you will get your result.