I have just migrated from 2.6.8 to 2.7.11 – I am using the %percent format for the one of my field. But that is showing the error like “Wrong formula format. Please check”.
Also stating – Field with”XXX” uniqueName is not defined.
Percentage values are not shown correctly.
Hello Gnanam Raghupathy Naidu,
Thank you for writing to us.
That warning means that the calculated formula is not correct. Usually, the reason for it is that you are referring to the field which is not defined.
Could you please provide the JSON config with that formula so we can check it on our side?
Waiting to hear from you.
Hello Dmytro Zvazhii,
It was working in the earlier version, the field used in the formula is not part of the dataset. do we option to hide the columns from the report like options may work for my problem.?
Thank you for your reply.
The warning pop-up window can be disabled by setting the
validateFormulas option to
Here is the JSFiddle example for illustration: https://jsfiddle.net/flexmonster/wsjy05n7/
Please note, that the results of formulas with non-existing fields may be unexpected.
We strongly recommend excluding such formulas from the reports (and the warning message can help to identify such formulas).
Please let us know if this helps to solve the problem.