Total is not showing wrong in n print excel report

[deep2021]

Hi,

I have created the template to show ton n values in n print excel report.

 Formulae's  are (highlighted) showing the total value from the qlik report.

However, the results are not matching.

Could you please assist me.

Thanks

[Lech_Miszkiewicz · Accepted solution]

how can we assist you when you are not giving us anything to work with other than information that it is not matching?

I guess you wrote your formulas wrong?

other suggestion - why dont you use excel to calculate totals just like shown in help side?

https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/ExcelReports/Excel-Reports-Nesteds.h...

[Frank_S]

I agree that there is far too little information to provide assistance.

Please include your expected results and actual results in detail using data,images including perhaps a snapshot of your NP template editor report design.

Using excel formulas 'might' work. It's very difficult to tell without seeing your template design.

In reality your best bet (best practice) is to create a Qlik Sense or QlikView QVW and create the bulk of your table there.

Then use NPrinting to drop your table from QV or QS into your NPrinting report to get your desired results.

[deep2021]

Thanks for the valuable reply. Sorry, hereon, I will add more details.