topic Re: I have 2 script amount ,How to sum these 2 script amount ? in QlikView https://community.qlik.com/t5/QlikView/I-have-2-script-amount-How-to-sum-these-2-script-amount/m-p/1155039#M630262 <HTML><HEAD></HEAD><BODY><P>Awesome, I am glad it did <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 07 Sep 2016 00:15:20 GMT sunny_talwar 2016-09-07T00:15:20Z I have 2 script amount ,How to sum these 2 script amount ? https://community.qlik.com/t5/QlikView/I-have-2-script-amount-How-to-sum-these-2-script-amount/m-p/1155036#M630259 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>May i know how to sum up the below script ?</P><P></P><TABLE><TBODY><TR><TD></TD><TD>if(right(@162:174T,1)='-', '-' &amp; left(@162:174T, len(@162:174T)-1),@162:174T) as ab18,</TD></TR></TBODY></TABLE><P></P><P></P><TABLE><TBODY><TR><TD></TD><TD>if(right(@179:191T,1)='-', '-' &amp; left(@179:191T, len(@179:191T)-1),@179:191T) as ab21,</TD></TR></TBODY></TABLE><P></P><P>I try below , it does not work :-</P><P></P><TABLE><TBODY><TR><TD></TD><TD>sum(</TD></TR><TR><TD></TD><TD>if(right(@162:174T,1)='-', '-' &amp; left(@162:174T, len(@162:174T)-1),@162:174T))</TD></TR><TR><TD></TD><TD>+</TD></TR><TR><TD></TD><TD>sum(</TD></TR><TR><TD></TD><TD>if(right(@179:191T,1)='-', '-' &amp; left(@179:191T, len(@179:191T)-1),@179:191T))</TD></TR><TR><TD></TD><TD> as ab1821,</TD></TR></TBODY></TABLE></BODY></HTML> Tue, 06 Sep 2016 23:46:20 GMT https://community.qlik.com/t5/QlikView/I-have-2-script-amount-How-to-sum-these-2-script-amount/m-p/1155036#M630259 paulyeo11 2016-09-06T23:46:20Z Re: I have 2 script amount ,How to sum these 2 script amount ? https://community.qlik.com/t5/QlikView/I-have-2-script-amount-How-to-sum-these-2-script-amount/m-p/1155037#M630260 <HTML><HEAD></HEAD><BODY><P>How about this:</P><P></P><P><STRONG>RangeSum(</STRONG></P><P><STRONG>I<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">f(Right(@162:174T,1)='-', '-' &amp; Left(@162:174T, Len(@162:174T)-1),@162:174T),</SPAN></STRONG></P><P><SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><STRONG>If(Right(@179:191T,1)='-', '-' &amp; Left(@179:191T, Len(@179:191T)-1),@179:191T)) </STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>as ab1821</STRONG></SPAN></SPAN></P></BODY></HTML> Tue, 06 Sep 2016 23:50:13 GMT https://community.qlik.com/t5/QlikView/I-have-2-script-amount-How-to-sum-these-2-script-amount/m-p/1155037#M630260 sunny_talwar 2016-09-06T23:50:13Z Re: I have 2 script amount ,How to sum these 2 script amount ? https://community.qlik.com/t5/QlikView/I-have-2-script-amount-How-to-sum-these-2-script-amount/m-p/1155038#M630261 <HTML><HEAD></HEAD><BODY><P>THank you sunny , it work</P></BODY></HTML> Wed, 07 Sep 2016 00:12:25 GMT https://community.qlik.com/t5/QlikView/I-have-2-script-amount-How-to-sum-these-2-script-amount/m-p/1155038#M630261 paulyeo11 2016-09-07T00:12:25Z Re: I have 2 script amount ,How to sum these 2 script amount ? https://community.qlik.com/t5/QlikView/I-have-2-script-amount-How-to-sum-these-2-script-amount/m-p/1155039#M630262 <HTML><HEAD></HEAD><BODY><P>Awesome, I am glad it did <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 07 Sep 2016 00:15:20 GMT https://community.qlik.com/t5/QlikView/I-have-2-script-amount-How-to-sum-these-2-script-amount/m-p/1155039#M630262 sunny_talwar 2016-09-07T00:15:20Z