topic Re: Problem with RangeSum in App Development https://community.qlik.com/t5/App-Development/Problem-with-RangeSum/m-p/1682666#M51961 <P>Change to :</P><P>&nbsp;</P><P>RangeSum(Above([Remaining Qty],0,Count(total [Remaining Qty])))</P><P>&nbsp;</P><P>and turn off sorting&nbsp;&nbsp;<span class="lia-unicode-emoji" title=":beaming_face_with_smiling_eyes:">😁</span></P><P>&nbsp;</P> Sat, 07 Mar 2020 22:52:37 GMT Rellik 2020-03-07T22:52:37Z Problem with RangeSum https://community.qlik.com/t5/App-Development/Problem-with-RangeSum/m-p/1682487#M51951 <P>I have a problem with this formula :</P><P>RangeSum(Above([Remaining Qty],0,Count(tOTAL &lt;[Remaining Qty]&gt;[Remaining Qty])))</P><P>Every time I put a dimension in the table the calculation fails ?</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Before.JPG" style="width: 200px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/29697i671B3BD2896F44FF/image-size/small?v=v2&amp;px=200" role="button" title="Before.JPG" alt="Before.JPG" /></span>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="After.JPG" style="width: 200px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/29698iC102E0F1ADD6EAC4/image-size/small?v=v2&amp;px=200" role="button" title="After.JPG" alt="After.JPG" /></span></P> Sat, 16 Nov 2024 03:03:45 GMT https://community.qlik.com/t5/App-Development/Problem-with-RangeSum/m-p/1682487#M51951 Eaun 2024-11-16T03:03:45Z Re: Problem with RangeSum https://community.qlik.com/t5/App-Development/Problem-with-RangeSum/m-p/1682666#M51961 <P>Change to :</P><P>&nbsp;</P><P>RangeSum(Above([Remaining Qty],0,Count(total [Remaining Qty])))</P><P>&nbsp;</P><P>and turn off sorting&nbsp;&nbsp;<span class="lia-unicode-emoji" title=":beaming_face_with_smiling_eyes:">😁</span></P><P>&nbsp;</P> Sat, 07 Mar 2020 22:52:37 GMT https://community.qlik.com/t5/App-Development/Problem-with-RangeSum/m-p/1682666#M51961 Rellik 2020-03-07T22:52:37Z