topic Re: Margin % in QlikView https://community.qlik.com/t5/QlikView/Margin/m-p/391220#M1152323 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Check whether sum(cost) gives null value or zero? If so, it display "-".</P><P></P><P><SPAN style="color: #737373; font-family: Arial; font-size: 12.727272033691406px; background-color: #ffffff;">= sum(sales)/Alt(sum(cost),1)</SPAN></P><P></P><P>please make sure, that field name are correct too.</P><P></P><P><SPAN style="color: #737373; font-family: Arial; font-size: 12.727272033691406px; background-color: #ffffff;">Hope it helps<BR /></SPAN></P></BODY></HTML> Tue, 23 Apr 2013 19:29:59 GMT MayilVahanan 2013-04-23T19:29:59Z Margin % https://community.qlik.com/t5/QlikView/Margin/m-p/391218#M1152319 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am trying to get a margin percentage in a straight table.&nbsp; I found another discussion that said to use sum(sales)/sum(cost).&nbsp; I when I click apply, the whole row shows as -.&nbsp;&nbsp; Any suggestions on what I might try instead?&nbsp; Thanks.</P></BODY></HTML> Tue, 23 Apr 2013 14:15:46 GMT https://community.qlik.com/t5/QlikView/Margin/m-p/391218#M1152319 2013-04-23T14:15:46Z Re: Margin % https://community.qlik.com/t5/QlikView/Margin/m-p/391219#M1152321 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Kindly post the QVW file.</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Tue, 23 Apr 2013 14:42:45 GMT https://community.qlik.com/t5/QlikView/Margin/m-p/391219#M1152321 kaushiknsolanki 2013-04-23T14:42:45Z Re: Margin % https://community.qlik.com/t5/QlikView/Margin/m-p/391220#M1152323 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Check whether sum(cost) gives null value or zero? If so, it display "-".</P><P></P><P><SPAN style="color: #737373; font-family: Arial; font-size: 12.727272033691406px; background-color: #ffffff;">= sum(sales)/Alt(sum(cost),1)</SPAN></P><P></P><P>please make sure, that field name are correct too.</P><P></P><P><SPAN style="color: #737373; font-family: Arial; font-size: 12.727272033691406px; background-color: #ffffff;">Hope it helps<BR /></SPAN></P></BODY></HTML> Tue, 23 Apr 2013 19:29:59 GMT https://community.qlik.com/t5/QlikView/Margin/m-p/391220#M1152323 MayilVahanan 2013-04-23T19:29:59Z