https://community.qlik.com/t5/App-Development/Division-calculation-in-Qlik/m-p/1993576#M82227 <P>If the expression you posted actually is the expression you tried to use without success then you should replace the en dash with a minus sign to get it working:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MarcoWedel_0-1666038220357.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/91488i300A86338D0D4874/image-size/large?v=v2&amp;px=999" role="button" title="MarcoWedel_0-1666038220357.png" alt="MarcoWedel_0-1666038220357.png" /></span></P> <P>hope this helps</P> <P>Marco</P> Mon, 17 Oct 2022 20:28:36 GMT MarcoWedel 2022-10-17T20:28:36Z https://community.qlik.com/t5/App-Development/Division-calculation-in-Qlik/m-p/1993530#M82223 <P>Hello, I have the following table of data. I need to perform the following calculation:</P> <P>(VALID_LINES – EXTRA_LINES)/VALID_LINES</P> <P>&nbsp;</P> <P>How can I tell Qlik to do this? I am thinking a custom dimension but not sure where to go from there.</P> <TABLE style="border-collapse: collapse; width: 153pt;" border="0" width="204" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 14.25pt;"> <TD width="68" height="19" style="height: 14.25pt; width: 51pt;">CATEGORY</TD> <TD width="68" style="width: 51pt;">VALID_LINES</TD> <TD width="68" style="width: 51pt;">EXTRA_LINES</TD> </TR> <TR style="height: 14.25pt;"> <TD height="19" style="height: 14.25pt;">A</TD> <TD align="right">2</TD> <TD align="right">0</TD> </TR> <TR style="height: 14.25pt;"> <TD height="19" style="height: 14.25pt;">B</TD> <TD align="right">3</TD> <TD align="right">0</TD> </TR> <TR style="height: 14.25pt;"> <TD height="19" style="height: 14.25pt;">C</TD> <TD align="right">1</TD> <TD align="right">0</TD> </TR> <TR style="height: 14.25pt;"> <TD height="19" style="height: 14.25pt;">D</TD> <TD align="right">1</TD> <TD align="right">0</TD> </TR> </TBODY> </TABLE> Mon, 17 Oct 2022 18:25:08 GMT https://community.qlik.com/t5/App-Development/Division-calculation-in-Qlik/m-p/1993530#M82223 laurenr171 2022-10-17T18:25:08Z https://community.qlik.com/t5/App-Development/Division-calculation-in-Qlik/m-p/1993562#M82226 <P>As below</P> <P><FONT color="#FF0000"><STRONG>Evaluate(</STRONG></FONT>(VALID_LINES-EXTRA_LINES)/VALID_LINES<FONT color="#FF0000"><STRONG>)</STRONG></FONT> as [New Measure]</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="BrunPierre_0-1666036165590.png" style="width: 408px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/91485i86FBDADCF2108114/image-dimensions/408x92?v=v2" width="408" height="92" role="button" title="BrunPierre_0-1666036165590.png" alt="BrunPierre_0-1666036165590.png" /></span></P> Mon, 17 Oct 2022 19:50:22 GMT https://community.qlik.com/t5/App-Development/Division-calculation-in-Qlik/m-p/1993562#M82226 BrunPierre 2022-10-17T19:50:22Z https://community.qlik.com/t5/App-Development/Division-calculation-in-Qlik/m-p/1993576#M82227 <P>If the expression you posted actually is the expression you tried to use without success then you should replace the en dash with a minus sign to get it working:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MarcoWedel_0-1666038220357.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/91488i300A86338D0D4874/image-size/large?v=v2&amp;px=999" role="button" title="MarcoWedel_0-1666038220357.png" alt="MarcoWedel_0-1666038220357.png" /></span></P> <P>hope this helps</P> <P>Marco</P> Mon, 17 Oct 2022 20:28:36 GMT https://community.qlik.com/t5/App-Development/Division-calculation-in-Qlik/m-p/1993576#M82227 MarcoWedel 2022-10-17T20:28:36Z