topic calculate only the Total row in straight table in App Development https://community.qlik.com/t5/App-Development/calculate-only-the-Total-row-in-straight-table/m-p/2128655#M91808 <P>Hi, I want to calculate only the <STRONG>Total</STRONG> row for&nbsp;<STRONG>Price For KM</STRONG> by the following way -&nbsp;<BR />Last (KM) / Last(Cumulative Amount)&nbsp; -&nbsp;&nbsp;</P> <P>The formula for 'Price For KM' is&nbsp; (KM/ Cumulative Amount)</P> <P><STRONG>Sample Date:&nbsp; &nbsp;</STRONG></P> <P>*&nbsp;In the original I present in a straight table</P> <TABLE border="1" width="100%"> <TBODY> <TR> <TD width="33.333333333333336%" height="25px"><FONT color="#0000FF"><STRONG>Order ID</STRONG></FONT></TD> <TD width="28.47654628476547%" height="25px"><FONT color="#0000FF"><STRONG>Cumulative Amount</STRONG></FONT></TD> <TD width="21.523453715234535%" height="25px"><FONT color="#0000FF"><STRONG>KM</STRONG></FONT></TD> <TD width="16.666666666666668%" height="25px"><FONT color="#0000FF"><STRONG>Price For KM</STRONG></FONT></TD> </TR> <TR> <TD width="33.333333333333336%" height="25px">10</TD> <TD width="28.47654628476547%" height="25px">200</TD> <TD width="21.523453715234535%" height="25px">1000</TD> <TD width="16.666666666666668%" height="25px">5</TD> </TR> <TR> <TD width="33.333333333333336%" height="25px">11</TD> <TD width="28.47654628476547%" height="25px">250</TD> <TD width="21.523453715234535%" height="25px">1400</TD> <TD width="16.666666666666668%" height="25px">5.6</TD> </TR> <TR> <TD width="33.333333333333336%" height="25px">12</TD> <TD width="28.47654628476547%" height="25px">280</TD> <TD width="21.523453715234535%" height="25px">1800</TD> <TD width="16.666666666666668%" height="25px">6.42</TD> </TR> <TR> <TD width="33.333333333333336%" height="29px">13</TD> <TD width="28.47654628476547%" height="29px">350</TD> <TD width="21.523453715234535%" height="29px">2500</TD> <TD width="16.666666666666668%" height="29px">7.14</TD> </TR> <TR> <TD width="33.333333333333336%" height="25px">&nbsp;</TD> <TD width="28.47654628476547%" height="25px">&nbsp;</TD> <TD width="21.523453715234535%" height="25px">&nbsp;</TD> <TD width="16.666666666666668%" height="25px"><FONT color="#FF0000"><STRONG>7.14</STRONG></FONT></TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>What is the way to do it?&nbsp;I tried several ways, I get NULL in Total line&nbsp;</P> <P>Thanks&nbsp;</P> Mon, 16 Oct 2023 07:45:42 GMT Xabinav 2023-10-16T07:45:42Z calculate only the Total row in straight table https://community.qlik.com/t5/App-Development/calculate-only-the-Total-row-in-straight-table/m-p/2128655#M91808 <P>Hi, I want to calculate only the <STRONG>Total</STRONG> row for&nbsp;<STRONG>Price For KM</STRONG> by the following way -&nbsp;<BR />Last (KM) / Last(Cumulative Amount)&nbsp; -&nbsp;&nbsp;</P> <P>The formula for 'Price For KM' is&nbsp; (KM/ Cumulative Amount)</P> <P><STRONG>Sample Date:&nbsp; &nbsp;</STRONG></P> <P>*&nbsp;In the original I present in a straight table</P> <TABLE border="1" width="100%"> <TBODY> <TR> <TD width="33.333333333333336%" height="25px"><FONT color="#0000FF"><STRONG>Order ID</STRONG></FONT></TD> <TD width="28.47654628476547%" height="25px"><FONT color="#0000FF"><STRONG>Cumulative Amount</STRONG></FONT></TD> <TD width="21.523453715234535%" height="25px"><FONT color="#0000FF"><STRONG>KM</STRONG></FONT></TD> <TD width="16.666666666666668%" height="25px"><FONT color="#0000FF"><STRONG>Price For KM</STRONG></FONT></TD> </TR> <TR> <TD width="33.333333333333336%" height="25px">10</TD> <TD width="28.47654628476547%" height="25px">200</TD> <TD width="21.523453715234535%" height="25px">1000</TD> <TD width="16.666666666666668%" height="25px">5</TD> </TR> <TR> <TD width="33.333333333333336%" height="25px">11</TD> <TD width="28.47654628476547%" height="25px">250</TD> <TD width="21.523453715234535%" height="25px">1400</TD> <TD width="16.666666666666668%" height="25px">5.6</TD> </TR> <TR> <TD width="33.333333333333336%" height="25px">12</TD> <TD width="28.47654628476547%" height="25px">280</TD> <TD width="21.523453715234535%" height="25px">1800</TD> <TD width="16.666666666666668%" height="25px">6.42</TD> </TR> <TR> <TD width="33.333333333333336%" height="29px">13</TD> <TD width="28.47654628476547%" height="29px">350</TD> <TD width="21.523453715234535%" height="29px">2500</TD> <TD width="16.666666666666668%" height="29px">7.14</TD> </TR> <TR> <TD width="33.333333333333336%" height="25px">&nbsp;</TD> <TD width="28.47654628476547%" height="25px">&nbsp;</TD> <TD width="21.523453715234535%" height="25px">&nbsp;</TD> <TD width="16.666666666666668%" height="25px"><FONT color="#FF0000"><STRONG>7.14</STRONG></FONT></TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>What is the way to do it?&nbsp;I tried several ways, I get NULL in Total line&nbsp;</P> <P>Thanks&nbsp;</P> Mon, 16 Oct 2023 07:45:42 GMT https://community.qlik.com/t5/App-Development/calculate-only-the-Total-row-in-straight-table/m-p/2128655#M91808 Xabinav 2023-10-16T07:45:42Z Re: calculate only the Total row in straight table https://community.qlik.com/t5/App-Development/calculate-only-the-Total-row-in-straight-table/m-p/2128864#M91818 <P>Try something like : <EM>Bottom("Price For KM")</EM> or <EM>Bottom("</EM><SPAN><EM>KM"/"Cumulative Amount")</EM> both should work.</SPAN></P> Mon, 16 Oct 2023 14:37:53 GMT https://community.qlik.com/t5/App-Development/calculate-only-the-Total-row-in-straight-table/m-p/2128864#M91818 vincent_ardiet_ 2023-10-16T14:37:53Z