Totals/Average values display

[Raju_6952]

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,

[Frank_S]

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...

[Raju_6952]

@Frank_S ,

Thanks for the suggestions but not working.

Regards

[Ruggero_Piccoli]

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 

[Frank_S]

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...