topic Re: Percentage calculation for totals in QlikView https://community.qlik.com/t5/QlikView/Percentage-calculation-for-totals/m-p/673728#M244655 <HTML><HEAD></HEAD><BODY><P>Try: 1 - sum(cost)/sum(price)</P></BODY></HTML> Tue, 07 Oct 2014 13:37:32 GMT Gysbert_Wassenaar 2014-10-07T13:37:32Z Percentage calculation for totals https://community.qlik.com/t5/QlikView/Percentage-calculation-for-totals/m-p/673727#M244654 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I have a calculation of ship profit % as sum((price - cost) / price) which is calculating correctly and displayed as % with the show in percent(%) checked for every row.</P><P>The issue i am having is that the total displayed at the bottom is showing the sum of all the percentages for the calculation instead of calculating the percentages of the totals.For the totals i am looking to display the total(price - cost) / total price.</P><P>example:</P><P>Price&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Cost&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; %</P><P>20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50%</P><P></P><P>30&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 66%</P><P>------------------------------------</P><P>50&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 116%&nbsp; -- Currently showing this which is sum of the two rows of data</P><P></P><P>50&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 60%&nbsp; --&nbsp; Need QV to show this which is&nbsp; (price - cost / price) as %age.&nbsp; </P><P></P><P>I would appreciate any recomendations to resolve this.</P></BODY></HTML> Tue, 07 Oct 2014 13:27:54 GMT https://community.qlik.com/t5/QlikView/Percentage-calculation-for-totals/m-p/673727#M244654 raghuvr33 2014-10-07T13:27:54Z Re: Percentage calculation for totals https://community.qlik.com/t5/QlikView/Percentage-calculation-for-totals/m-p/673728#M244655 <HTML><HEAD></HEAD><BODY><P>Try: 1 - sum(cost)/sum(price)</P></BODY></HTML> Tue, 07 Oct 2014 13:37:32 GMT https://community.qlik.com/t5/QlikView/Percentage-calculation-for-totals/m-p/673728#M244655 Gysbert_Wassenaar 2014-10-07T13:37:32Z Re: Percentage calculation for totals https://community.qlik.com/t5/QlikView/Percentage-calculation-for-totals/m-p/673729#M244656 <HTML><HEAD></HEAD><BODY><P>Thanks that did it with total mode as expression total.</P></BODY></HTML> Tue, 07 Oct 2014 13:41:16 GMT https://community.qlik.com/t5/QlikView/Percentage-calculation-for-totals/m-p/673729#M244656 raghuvr33 2014-10-07T13:41:16Z