topic How to sum null values ? in QlikView https://community.qlik.com/t5/QlikView/How-to-sum-null-values/m-p/546020#M203959 <HTML><HEAD></HEAD><BODY><P>How do I sum different fields even if some of them are "null" ?</P><P></P><P>When I do it something like these :</P><P></P><P>45 + "Null value" + 75 I get "Null value" but I want 120.</P></BODY></HTML> Fri, 11 Oct 2013 12:58:01 GMT vivientexier 2013-10-11T12:58:01Z How to sum null values ? https://community.qlik.com/t5/QlikView/How-to-sum-null-values/m-p/546020#M203959 <HTML><HEAD></HEAD><BODY><P>How do I sum different fields even if some of them are "null" ?</P><P></P><P>When I do it something like these :</P><P></P><P>45 + "Null value" + 75 I get "Null value" but I want 120.</P></BODY></HTML> Fri, 11 Oct 2013 12:58:01 GMT https://community.qlik.com/t5/QlikView/How-to-sum-null-values/m-p/546020#M203959 vivientexier 2013-10-11T12:58:01Z Re: How to sum null values ? https://community.qlik.com/t5/QlikView/How-to-sum-null-values/m-p/546021#M203960 <HTML><HEAD></HEAD><BODY><P>Hi Vivien,</P><P></P><P>You should not sum with the "+" sign. Use the "RangeSum()" function.</P><P></P><P>Try RangeSum(45, "Null Value", 75), you will get your result.</P></BODY></HTML> Fri, 11 Oct 2013 12:58:16 GMT https://community.qlik.com/t5/QlikView/How-to-sum-null-values/m-p/546021#M203960 ecahen 2013-10-11T12:58:16Z