https://community.qlik.com/t5/QlikView/Qlikview-RangeSum-function/m-p/1543899#M439658 <P>You have an extra Sum in there... try this</P><PRE>RangeSum(Above((Sum(EST_Automate_TC) + Sum(EST_Manual_TC))/(NetWorkDays([Analysis end Date Planned],[Test Completion date])), 0, RowNo()))</PRE> Wed, 13 Feb 2019 18:58:34 GMT sunny_talwar 2019-02-13T18:58:34Z https://community.qlik.com/t5/QlikView/Qlikview-RangeSum-function/m-p/1543876#M439654 <P>Hi,</P><P>Can anyone help me in solving the below expression ?</P><P><SPAN>RangeSum(Above(Sum((Sum (EST_Automate_TC)+Sum (EST_Manual_TC))/(networkdays([Analysis end Date Planned],[Test Completion date])), 0, RowNo())))</SPAN></P><P><SPAN>I need the below expression to be put under Rangesum function.</SPAN></P><P><STRONG>(Sum (EST_Automate_TC)+Sum (EST_Manual_TC))/(networkdays([Analysis end Date Planned],[Test Completion date])</STRONG></P> Wed, 13 Feb 2019 18:07:47 GMT https://community.qlik.com/t5/QlikView/Qlikview-RangeSum-function/m-p/1543876#M439654 kiranb13 2019-02-13T18:07:47Z https://community.qlik.com/t5/QlikView/Qlikview-RangeSum-function/m-p/1543893#M439656 <P>What is the reason for using rangesum in <STRONG>(Sum (EST_Automate_TC)+Sum (EST_Manual_TC))/(networkdays([Analysis end Date Planned],[Test Completion date]) ??<BR /></STRONG></P> Wed, 13 Feb 2019 18:49:24 GMT https://community.qlik.com/t5/QlikView/Qlikview-RangeSum-function/m-p/1543893#M439656 pradosh_thakur 2019-02-13T18:49:24Z https://community.qlik.com/t5/QlikView/Qlikview-RangeSum-function/m-p/1543899#M439658 <P>You have an extra Sum in there... try this</P><PRE>RangeSum(Above((Sum(EST_Automate_TC) + Sum(EST_Manual_TC))/(NetWorkDays([Analysis end Date Planned],[Test Completion date])), 0, RowNo()))</PRE> Wed, 13 Feb 2019 18:58:34 GMT https://community.qlik.com/t5/QlikView/Qlikview-RangeSum-function/m-p/1543899#M439658 sunny_talwar 2019-02-13T18:58:34Z