🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all the hot features!
Get Free Trial

Percentage format is not working

Gnanam Raghupathy Naidu asked on August 6, 2019

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.

3 answers

Dmytro Zvazhii Dmytro Zvazhii Flexmonster August 6, 2019

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.



Gnanam Raghupathy Naidu August 14, 2019

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.?

Vera Didenko Vera Didenko Flexmonster August 15, 2019

Hello, Gnanam,

Thank you for your reply.

The warning pop-up window can be disabled by setting the validateFormulas option to false.
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.

Best Regards,

Please login or Register to Submit Answer