topic Re: Cumulative sum not working in QlikView https://community.qlik.com/t5/QlikView/Cumulative-sum-not-working/m-p/1442712#M432745 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Instead of using RangeSum() you can try with full accumulation.</P><P></P><P>Regards,</P><P>Prashant Sangle</P></BODY></HTML> Thu, 09 Nov 2017 06:40:32 GMT PrashantSangle 2017-11-09T06:40:32Z Cumulative sum not working https://community.qlik.com/t5/QlikView/Cumulative-sum-not-working/m-p/1442711#M432744 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have created the cumulative sum but for sales order column it is not working.</P><P></P><P>Please suggest.</P><P></P><P>thanks</P></BODY></HTML> Thu, 09 Nov 2017 06:33:59 GMT https://community.qlik.com/t5/QlikView/Cumulative-sum-not-working/m-p/1442711#M432744 kishorj1982 2017-11-09T06:33:59Z Re: Cumulative sum not working https://community.qlik.com/t5/QlikView/Cumulative-sum-not-working/m-p/1442712#M432745 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Instead of using RangeSum() you can try with full accumulation.</P><P></P><P>Regards,</P><P>Prashant Sangle</P></BODY></HTML> Thu, 09 Nov 2017 06:40:32 GMT https://community.qlik.com/t5/QlikView/Cumulative-sum-not-working/m-p/1442712#M432745 PrashantSangle 2017-11-09T06:40:32Z Re: Cumulative sum not working https://community.qlik.com/t5/QlikView/Cumulative-sum-not-working/m-p/1442713#M432746 <HTML><HEAD></HEAD><BODY><P>Also, Your Rangesum() expression is working You need to use </P><P>rangesum(Above(sum(SalesOrder ),0,RowNo(Total))) </P><P>instead of</P><P>rangesum(Above(sum(ThirdPartySales),0,RowNo(Total))) </P></BODY></HTML> Thu, 09 Nov 2017 06:43:46 GMT https://community.qlik.com/t5/QlikView/Cumulative-sum-not-working/m-p/1442713#M432746 PrashantSangle 2017-11-09T06:43:46Z