Dear visitor, despite the COVID-19 outbreak, our team continues operating at full speed.

Also, here is the form where you can apply for a special discount and we will contact you with possible options. Stay safe and continue achieving your business goals.

Fill the form
Get Free Trial
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 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 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:
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