Calculate Percentage in Nprinting Excel report

[selvakumara]

Team,

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.  Rightnow , Its showing percentage for one row not for all rows. Please help me on this.

Thanks in advance.

[rubenmarin]

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.

After this you can add the <deleterow> element in row 6 to delete this extra row.

And the calculation of percentage on row 7 will use the sum of all rows.