topic Running Balance in a Pivot table, what's wrong with my code!!!!! in QlikView https://community.qlik.com/t5/QlikView/Running-Balance-in-a-Pivot-table-what-s-wrong-with-my-code/m-p/246736#M94030 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am making a pivot table and attempting to have the last column hold a running balance based on the other columns. </P><P></P><P>Here is what I want in plain English:</P><P></P><P>IF this is the first row, THEN take a field called 'JuneStartBal' and add to that value the Sum of a field called 'TotalRecByItem' then subtract from that the sum of a field called TotalReqByItem. ELSE (if this is not the first row), get the value from the previous row and add to that value the Sum of a field called 'TotalRecByItem' then subtract from that the sum of a field called TotalReqByItem.</P><P></P><P></P><P></P><P>Here is my broken code:</P><P></P><P>if(rowno()=1, JuneStartBal + (Sum ([TotalRecByItem])) - (Sum ([TotalReqByItem]) ), peek(Rowno() -1) + (Sum ([TotalRecByItem]) - (Sum ([TotalReqByItem]))))</P><P></P><P><STRONG style=": ; color: #ff0000; font-size: 8pt;"> </STRONG></P><P></P><P>Please help me!!! Thanks to all who assist!</P><P></P></BODY></HTML> Thu, 30 Jun 2011 21:49:28 GMT 2011-06-30T21:49:28Z Running Balance in a Pivot table, what's wrong with my code!!!!! https://community.qlik.com/t5/QlikView/Running-Balance-in-a-Pivot-table-what-s-wrong-with-my-code/m-p/246736#M94030 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am making a pivot table and attempting to have the last column hold a running balance based on the other columns. </P><P></P><P>Here is what I want in plain English:</P><P></P><P>IF this is the first row, THEN take a field called 'JuneStartBal' and add to that value the Sum of a field called 'TotalRecByItem' then subtract from that the sum of a field called TotalReqByItem. ELSE (if this is not the first row), get the value from the previous row and add to that value the Sum of a field called 'TotalRecByItem' then subtract from that the sum of a field called TotalReqByItem.</P><P></P><P></P><P></P><P>Here is my broken code:</P><P></P><P>if(rowno()=1, JuneStartBal + (Sum ([TotalRecByItem])) - (Sum ([TotalReqByItem]) ), peek(Rowno() -1) + (Sum ([TotalRecByItem]) - (Sum ([TotalReqByItem]))))</P><P></P><P><STRONG style=": ; color: #ff0000; font-size: 8pt;"> </STRONG></P><P></P><P>Please help me!!! Thanks to all who assist!</P><P></P></BODY></HTML> Thu, 30 Jun 2011 21:49:28 GMT https://community.qlik.com/t5/QlikView/Running-Balance-in-a-Pivot-table-what-s-wrong-with-my-code/m-p/246736#M94030 2011-06-30T21:49:28Z Running Balance in a Pivot table, what's wrong with my code!!!!! https://community.qlik.com/t5/QlikView/Running-Balance-in-a-Pivot-table-what-s-wrong-with-my-code/m-p/246737#M94031 <HTML><HEAD></HEAD><BODY><P> <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /> stumped</P></BODY></HTML> Fri, 01 Jul 2011 16:25:31 GMT https://community.qlik.com/t5/QlikView/Running-Balance-in-a-Pivot-table-what-s-wrong-with-my-code/m-p/246737#M94031 2011-07-01T16:25:31Z Running Balance in a Pivot table, what's wrong with my code!!!!! https://community.qlik.com/t5/QlikView/Running-Balance-in-a-Pivot-table-what-s-wrong-with-my-code/m-p/246738#M94032 <HTML><HEAD></HEAD><BODY><P> ttt</P></BODY></HTML> Fri, 01 Jul 2011 22:31:03 GMT https://community.qlik.com/t5/QlikView/Running-Balance-in-a-Pivot-table-what-s-wrong-with-my-code/m-p/246738#M94032 2011-07-01T22:31:03Z Running Balance in a Pivot table, what's wrong with my code!!!!! https://community.qlik.com/t5/QlikView/Running-Balance-in-a-Pivot-table-what-s-wrong-with-my-code/m-p/246739#M94033 <HTML><HEAD></HEAD><BODY><P> One last try, I always stump this forum <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Tue, 05 Jul 2011 15:09:21 GMT https://community.qlik.com/t5/QlikView/Running-Balance-in-a-Pivot-table-what-s-wrong-with-my-code/m-p/246739#M94033 2011-07-05T15:09:21Z