NPrinting Cell Reference Problems

[the_murkle_man]

Hi Guys,

I have recently created an NPrinting Report showing total sales by month and financial year.

This has been working perfectly and I had it running on a monthly schedule.

My financial year field is derived by a variable set in the loading script.

The problem I am facing is that due to the change in financial year, by cell references are now out of sync.

For example cell reference 'CitySales 1_14' which previously was my total column, now does not exist.

The total column is now 'CitySales 1_3'.

Is there a method to get Qlikview to almost auto populate the cells with 0, so there is always data in there to ensure the cell references work?

Thanks in advance.

Regards

Jim