Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Vivien,
You should not sum with the "+" sign. Use the "RangeSum()" function.
Try RangeSum(45, "Null Value", 75), you will get your result.
Hi Vivien,
You should not sum with the "+" sign. Use the "RangeSum()" function.
Try RangeSum(45, "Null Value", 75), you will get your result.