topic Re: Totals/Average values display in Qlik NPrinting

Totals/Average values display

Raju_6952 — Mon, 03 Jun 2024 16:38:20 GMT

Hi,

I have a table created with one dimension and 6 measures created which has 45 rows of data

Created nprintinng report by adding that object as table in nprintinng excel report template.now my requirement is to calculate the average for all the 45 rows of data .I tried creating formulas but it's giving some what wrong value as I have null value in one row out of 45 rows of data.

Regards,

Re: Totals/Average values display

Frank_S — Mon, 03 Jun 2024 21:51:12 GMT

Try remove the 'expand range' checkbox feature in NPrinting Designer if you haven't already done so. Retest.

If that doesn't help, then try:

1. Open your NPrinting Excel Report

2. Ensure the columns you are using are formatted using 'numeric' format and save the xlsx file

3. Preview

That might work but haven't tested.

Let us know if it helps...if not others here may have another solution.

Kind regards...

Re: Totals/Average values display

Raju_6952 — Tue, 04 Jun 2024 06:29:40 GMT

@Frank_S ,

Thanks for the suggestions but not working.

Regards

Re: Totals/Average values display

Ruggero_Piccoli — Tue, 04 Jun 2024 07:57:24 GMT

Hi,

Try to export only the table in Excel and after add the needed native Excel formulas. Be sure they works correctly because if not it could be something that need to be solved on Excel side.

If you are not able to solve please post some screenshots of your template: it will be easier to understand what could be the right way to configure it if we can see it.

Best Regards,

Ruggero

Re: Totals/Average values display

Frank_S — Tue, 04 Jun 2024 14:33:42 GMT

In fact if you can provide a sample app and a copy of the exported report template, we can test it for you.

Kind regards...