https://community.qlik.com/t5/Water-Cooler/Percentage-Calculation/m-p/1622508#M10360 <P>Thanks you very much it worked.</P> Wed, 11 Sep 2019 08:57:17 GMT Eston_Sello 2019-09-11T08:57:17Z https://community.qlik.com/t5/Water-Cooler/Percentage-Calculation/m-p/1622455#M10358 <P>Good day,</P> <P>Please assist, I'm still new in Qlik.</P> <P>I want to use grand total number to calculate the percentage but I struggling.</P> <P>I have manually hard coded the grant total (424730) in the expression field to get my&nbsp; percentages.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="clipboard_image_1.png" style="width: 399px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/18931i786E340D95A0D379/image-size/medium?v=v2&amp;px=400" role="button" title="clipboard_image_1.png" alt="clipboard_image_1.png" /></span></P> <P>&nbsp;</P> <P>Thanks in advance.</P> Fri, 07 Feb 2020 22:18:16 GMT https://community.qlik.com/t5/Water-Cooler/Percentage-Calculation/m-p/1622455#M10358 Eston_Sello 2020-02-07T22:18:16Z https://community.qlik.com/t5/Water-Cooler/Percentage-Calculation/m-p/1622502#M10359 <P>You need to use total function:</P><P>Sum(Postpaid)/Sum(Total [Calls Received])</P> Wed, 11 Sep 2019 08:50:10 GMT https://community.qlik.com/t5/Water-Cooler/Percentage-Calculation/m-p/1622502#M10359 DavidM 2019-09-11T08:50:10Z https://community.qlik.com/t5/Water-Cooler/Percentage-Calculation/m-p/1622508#M10360 <P>Thanks you very much it worked.</P> Wed, 11 Sep 2019 08:57:17 GMT https://community.qlik.com/t5/Water-Cooler/Percentage-Calculation/m-p/1622508#M10360 Eston_Sello 2019-09-11T08:57:17Z