Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How repeat formula in all lines of my excel nPrinting report

Hi,

I have an Excel Report in NPinting and in this report we have a table with x lines value.

My 2 first colums are Qlikview fields and my third column is an excel formula.

When I published my report, the excel formula stays on my first line but it isn't repeated on others lines. 

How can I do to repeat automatically this formula on all lines ?

Thanks

1 Solution

Accepted Solutions
Not applicable
Author

You need to insert the qlikview fields by adding the chart as a level and not as data.

See attached image of template which has formulas which repeat.

NB if you want totals at the bottom of the column, the formula to insert must contain row 10 - 12 inclusive.

View solution in original post

2 Replies
Not applicable
Author

You need to insert the qlikview fields by adding the chart as a level and not as data.

See attached image of template which has formulas which repeat.

NB if you want totals at the bottom of the column, the formula to insert must contain row 10 - 12 inclusive.

Not applicable
Author

Thank you ! The result is perfect !