https://community.qlik.com/t5/Qlik-Automate/Calculate-Percentage-in-Nprinting-Excel-report/m-p/2091812#M2137 <P>Hi, this question lacks on information on how is your report created. I would imagine that you have a table and you have added all columns in a row of the excel report. You first will need to add a calculated column that summarizes all rows data, if you've inserted the columns in row 5, in column A row 7 you can add the formula to summarize all creating the expression SUM(A5:A6), when nprinting add new rows the expression will change to cover all the range of new rows created.</P> <P>After this you can add the &lt;deleterow&gt; element in row 6 to delete this extra row.</P> <P>And the calculation of percentage on row 7 will use the sum of all rows.</P> Sun, 09 Jul 2023 07:12:26 GMT rubenmarin 2023-07-09T07:12:26Z https://community.qlik.com/t5/Qlik-Automate/Calculate-Percentage-in-Nprinting-Excel-report/m-p/2091209#M2129 <P>Team,</P> <P>&nbsp;</P> <P>I have multiple columns in Nprinting report. I want to calculate the percentage based on the other two columns. but it's working the way I expected.&nbsp; Rightnow , Its showing percentage for one row not for all rows. Please help me on this.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="selvakumara_0-1688660625374.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/111703i628CA245838CCAAC/image-size/medium?v=v2&amp;px=400" role="button" title="selvakumara_0-1688660625374.png" alt="selvakumara_0-1688660625374.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>Thanks in advance.</P> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 06 Jul 2023 16:24:43 GMT https://community.qlik.com/t5/Qlik-Automate/Calculate-Percentage-in-Nprinting-Excel-report/m-p/2091209#M2129 selvakumara 2023-07-06T16:24:43Z https://community.qlik.com/t5/Qlik-Automate/Calculate-Percentage-in-Nprinting-Excel-report/m-p/2091812#M2137 <P>Hi, this question lacks on information on how is your report created. I would imagine that you have a table and you have added all columns in a row of the excel report. You first will need to add a calculated column that summarizes all rows data, if you've inserted the columns in row 5, in column A row 7 you can add the formula to summarize all creating the expression SUM(A5:A6), when nprinting add new rows the expression will change to cover all the range of new rows created.</P> <P>After this you can add the &lt;deleterow&gt; element in row 6 to delete this extra row.</P> <P>And the calculation of percentage on row 7 will use the sum of all rows.</P> Sun, 09 Jul 2023 07:12:26 GMT https://community.qlik.com/t5/Qlik-Automate/Calculate-Percentage-in-Nprinting-Excel-report/m-p/2091812#M2137 rubenmarin 2023-07-09T07:12:26Z