NPrinting cannot evaluate calculations when you use a reference to a cell in Excel
Article Number: 000045597 | Last Modified: 2018/11/21
You have created a cell with a reference to another cell containing a calculation. This calculation may be done on NPrinting tags, for example you may want to calculate a percentage of a value you imported with an Variable in the template.
When you preview or run the report, the correct result is not shown: you see something like "#VALUEERROR". This occurs especially if you choose PDF as output.
The problem is not due to the use of the variables, formulas or other NPrinting objects.
Generally, it is possible to create a reference in the NPrinting templates, but the formulas are not always calculated, especially if you preview in PDF format.
A simple solution is to do the calculation directly in the variable or in the NPrinting formula. You can drag directly the NPrinting variable or formula in the reference cell without any Excel calculations.