https://community.qlik.com/t5/QlikView/Please-help-me-on-rangesum-expression/m-p/1508553#M436476 <P>The below range sum is wrongly displaying cumulative totals. The total count is taking as initial jan value and cumulating until Nov. Please help</P><P>rangesum(above(Count({&lt;[TB_MASTER_CALENDER.Year]={"$(=$(VSelectYr))"},[CASE_xxx.COUNT_CASES_MM]={'1'}&gt;}<BR />[CASE_xxx.CASE_ID]),0,rowno()))</P><P>&nbsp;</P> Sun, 18 Nov 2018 02:13:24 GMT Anonymous 2018-11-18T02:13:24Z https://community.qlik.com/t5/QlikView/Please-help-me-on-rangesum-expression/m-p/1508553#M436476 <P>The below range sum is wrongly displaying cumulative totals. The total count is taking as initial jan value and cumulating until Nov. Please help</P><P>rangesum(above(Count({&lt;[TB_MASTER_CALENDER.Year]={"$(=$(VSelectYr))"},[CASE_xxx.COUNT_CASES_MM]={'1'}&gt;}<BR />[CASE_xxx.CASE_ID]),0,rowno()))</P><P>&nbsp;</P> Sun, 18 Nov 2018 02:13:24 GMT https://community.qlik.com/t5/QlikView/Please-help-me-on-rangesum-expression/m-p/1508553#M436476 Anonymous 2018-11-18T02:13:24Z https://community.qlik.com/t5/QlikView/Please-help-me-on-rangesum-expression/m-p/1508571#M436477 Please post a small QS app that demonstrates the problem and explain why you think that's wrong. What's the anwer you expect? Sun, 18 Nov 2018 06:56:11 GMT https://community.qlik.com/t5/QlikView/Please-help-me-on-rangesum-expression/m-p/1508571#M436477 Gysbert_Wassenaar 2018-11-18T06:56:11Z