Nprint Excel Report - Formula Changes when Report is ran

[#1]

Hi,

I am trying to add up two different qlikview tables that are being brought in my Nprint excel report. Trying to add up each's daily sales.

However, when I create my formlua to be = "tab1" a9+ "tab2" a9 and then run the report, the formula changes to = "tab1" a22+ "tab2" a22 once the data is brought in.

Does anyone know how to write the formula so that it doesn't get effected when I run the report?

My issue in pictures is attached,

Thanks.

[avinashelite]

Do you have any other object placed before a9?? i.e any object placed from a1 to a8 ?? if so then based on that size of that chart the cell values are changing dynamically ...in order to avoid don't place any charts or object from a1 to a8 or make sure the chart cell doesn't exceed this range

Hope this helps you

[#3]

Hi,

When building the Report in the Nprinting report editor (ie where you drag in tables etc to the embedded excel instance), Select the table, and in its properties (bottom let corner of the screen), untick "Expand Range"

Hope this helps

[Daniel_Jenkins]

Hi Christopher,

If you uncheck Expand Range your formula will not be pushed down and could be overwritten depending on the number of rows returned. If you use absolute cell references you will still not get what you want as $C$10 will change to $C$22 in your case. I suggest you use the INDIRECT() function and absolute cell references.

You may also want to hide the referenced cells (D2) containing the absolute reference by changing the font colour to white.

HTH - Daniel.