Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.