topic Re: Column calculations in QlikView https://community.qlik.com/t5/QlikView/Column-calculations/m-p/1171489#M912576 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>=num(RangeSum(Above(Sum(Margin), 0, RowNo()))/RangeSum(Above(Sum(Sales), 0, RowNo())))</STRONG></P></BODY></HTML> Mon, 30 May 2016 12:09:11 GMT sunny_talwar 2016-05-30T12:09:11Z Column calculations https://community.qlik.com/t5/QlikView/Column-calculations/m-p/1171488#M912575 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please see attached.</P><P></P><P>I have two tables - Table A has the raw data and Table B has the same data except with Full Accumulation.</P><P></P><P>In Table B, Column(2)/Column(1)&nbsp; does not come out with the right result.</P><P></P><P>Any idea on what the correct expression should be for Table B?</P><P></P><P>Thanks</P><P>Shamit</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Column-calculations/m-p/1171488#M912575 shamitshah 2020-11-25T16:16:04Z Re: Column calculations https://community.qlik.com/t5/QlikView/Column-calculations/m-p/1171489#M912576 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>=num(RangeSum(Above(Sum(Margin), 0, RowNo()))/RangeSum(Above(Sum(Sales), 0, RowNo())))</STRONG></P></BODY></HTML> Mon, 30 May 2016 12:09:11 GMT https://community.qlik.com/t5/QlikView/Column-calculations/m-p/1171489#M912576 sunny_talwar 2016-05-30T12:09:11Z Re: Column calculations https://community.qlik.com/t5/QlikView/Column-calculations/m-p/1171490#M912577 <HTML><HEAD></HEAD><BODY><P>Hi Sunny,</P><P></P><P>Many thanks.</P><P></P><P>Shamit</P></BODY></HTML> Mon, 30 May 2016 12:24:32 GMT https://community.qlik.com/t5/QlikView/Column-calculations/m-p/1171490#M912577 shamitshah 2016-05-30T12:24:32Z