topic Re: what is the range of sum function ? in QlikView https://community.qlik.com/t5/QlikView/what-is-the-range-of-sum-function/m-p/862654#M996122 <HTML><HEAD></HEAD><BODY><P>The rangesum function calculates the sum of the values passed to the function. All non-numeric values are treated as 0. That makes it useful if you have to deal with nulls and don't want a null as result. 11 + 2/0&nbsp; will return null because 2 divided by 0 returns null. But rangesum(11, <SPAN style="font-size: 13.3333330154419px;">2/0</SPAN>) will return 11.</P></BODY></HTML> Fri, 19 Jun 2015 17:09:20 GMT Gysbert_Wassenaar 2015-06-19T17:09:20Z what is the range of sum function ? https://community.qlik.com/t5/QlikView/what-is-the-range-of-sum-function/m-p/862652#M996120 <HTML><HEAD></HEAD><BODY><P>hi to everyone can you please explain me .......... what is the range of sum function ?</P></BODY></HTML> Fri, 19 Jun 2015 13:28:10 GMT https://community.qlik.com/t5/QlikView/what-is-the-range-of-sum-function/m-p/862652#M996120 2015-06-19T13:28:10Z Re: what is the range of sum function ? https://community.qlik.com/t5/QlikView/what-is-the-range-of-sum-function/m-p/862653#M996121 <HTML><HEAD></HEAD><BODY><P>Are you intending to ask for <STRONG>RangeSum()</STRONG> function??? If yes than you might find these link to be useful</P><P></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"> </SPAN><A href="https://community.qlik.com/qlik-blogpost/2787">Accumulative Sums</A></P><P><A href="https://community.qlik.com/docs/DOC-4252">Calculating rolling n-period totals, averages or other aggregations</A></P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Fri, 19 Jun 2015 16:38:06 GMT https://community.qlik.com/t5/QlikView/what-is-the-range-of-sum-function/m-p/862653#M996121 sunny_talwar 2015-06-19T16:38:06Z Re: what is the range of sum function ? https://community.qlik.com/t5/QlikView/what-is-the-range-of-sum-function/m-p/862654#M996122 <HTML><HEAD></HEAD><BODY><P>The rangesum function calculates the sum of the values passed to the function. All non-numeric values are treated as 0. That makes it useful if you have to deal with nulls and don't want a null as result. 11 + 2/0&nbsp; will return null because 2 divided by 0 returns null. But rangesum(11, <SPAN style="font-size: 13.3333330154419px;">2/0</SPAN>) will return 11.</P></BODY></HTML> Fri, 19 Jun 2015 17:09:20 GMT https://community.qlik.com/t5/QlikView/what-is-the-range-of-sum-function/m-p/862654#M996122 Gysbert_Wassenaar 2015-06-19T17:09:20Z Re: what is the range of sum function ? https://community.qlik.com/t5/QlikView/what-is-the-range-of-sum-function/m-p/862655#M996123 <HTML><HEAD></HEAD><BODY><P>I did not know that. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Good to know that as well. Thanks <A _jive_internal="true" href="https://community.qlik.com/people/gwassenaar">Gysbert Wassenaar</A></P></BODY></HTML> Fri, 19 Jun 2015 17:11:26 GMT https://community.qlik.com/t5/QlikView/what-is-the-range-of-sum-function/m-p/862655#M996123 sunny_talwar 2015-06-19T17:11:26Z