Hi thanks for a reply but Ive sent through an image of my actual report template, which as you can see is already set out as a table with levels. I have entered the formula below but as mentioned it doesnt carry through to all the rows.
I dont think you answer will help with my question but thank you anyway.
In this case if your Variance area is a "Table" entity in Excel you need to make sure that hte calculation is also populated to the row below of your "=IF(Error(D6-D10,"") which effectively will be =IF(Error(D7-D11,"").
I know that htis will create one additional row so you will have to use "deleterow" functionality in NPritntign to remove it.
see screenshots for referenece
3. add table and extra expression below
4. add deleterow functionality
I have tried that also and still getting the same error.
I do think its still an NPrinting issue in that I am getting six rows in the output due to having more than one entity in the template, and as noted before I am using levels not inserting a straight table. The formula doesnt take into account that there is multiple rows in the final report. I've tried various work around's but can get it to repeat the calculation for each row.