https://community.qlik.com/t5/App-Development/RangeSum-Function-calculation-should-start-from-current-month/m-p/1595637#M43839 <P>RangeSum Function calculation should start from current month and for the previous months it should show the actual data</P><P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Range Sum Function Current scenario" style="width: 481px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/14357iED56E2B4214AE04E/image-dimensions/481x182?v=v2" width="481" height="182" role="button" title="RangeSum.png" alt="Range Sum Function Current scenario" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Range Sum Function Current scenario</span></span></P><P>&nbsp;</P><P>Below is the formula I am using right nkw</P><P>RangeSum(Above(Count({$&lt;FC_Actual={'1'}&gt;} FC_Envelope),0, RowNo()))</P> Wed, 22 Dec 2021 20:40:09 GMT rajeshmachan 2021-12-22T20:40:09Z https://community.qlik.com/t5/App-Development/RangeSum-Function-calculation-should-start-from-current-month/m-p/1595637#M43839 <P>RangeSum Function calculation should start from current month and for the previous months it should show the actual data</P><P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Range Sum Function Current scenario" style="width: 481px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/14357iED56E2B4214AE04E/image-dimensions/481x182?v=v2" width="481" height="182" role="button" title="RangeSum.png" alt="Range Sum Function Current scenario" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Range Sum Function Current scenario</span></span></P><P>&nbsp;</P><P>Below is the formula I am using right nkw</P><P>RangeSum(Above(Count({$&lt;FC_Actual={'1'}&gt;} FC_Envelope),0, RowNo()))</P> Wed, 22 Dec 2021 20:40:09 GMT https://community.qlik.com/t5/App-Development/RangeSum-Function-calculation-should-start-from-current-month/m-p/1595637#M43839 rajeshmachan 2021-12-22T20:40:09Z