Get Free Trial
Get Free Trial

Formula references a non-existing field in Flexmonster 2.7

Vesa Tähkävuori asked on April 2, 2019

Hi,
this is (apparently?) new in Flexmonster 2.7 which we are just trying out. When a formula is referencing a non-existing field, we get the following error (see attached screenshot). What is the best way out of this? Do we have to edit each of the pivot JSONs programmatically? We are storing hundreds of these in our database. With our current deadline we simply need the warning not to show up to the user, the formula itself is not a priority now as it is not currently being used.

4 answers

Public
Vesa Tähkävuori April 2, 2019

Here’s a closer look at the field “Closing price” that does not exist in all of the pivots.

Public
Tanya Gryshko Flexmonster April 2, 2019

Hello, Vesa,

Thank you for writing to us.

We would like to inform you that the component shows the warning message for unexisting uniqueName in formulas starting from version 2.6.9. Our development team can add an option which will hide this warning from the user. This feature can be added on April the 22nd. Would that work for you?

Waiting for your reply.

Regards,
Tanya

Public
Vesa Tähkävuori April 3, 2019

Hi Tanya,
we will use another solution at this time, but it’s probably a good feature to add. Thanks.

Public
Vera Didenko Flexmonster April 26, 2019

Hello, Vesa,
 
We are glad to announce that we have released a new version of Flexmonster.
 
A new validateFormulas property was added to Options Object. Indicates whether the validation will be performed for calculated values (true) or not (false). In case the validation is turned on and the report contains invalid formula, the “Wrong formula format” alert message is shown. To turn off the “Wrong formula format” alert message, set the validateFormulas property to false. Default value: true.
 
We have prepared a JSFiddle example for illustration: https://jsfiddle.net/flexmonster/wsjy05n7/
In this example, the calculated value “Sum(rice)” is highlighted (On purpose “rice” instead of “Price” is specified). Notice no warning message appears when the grid is rendered.
 
You are welcome to update the component.
 
Please let us know if everything works fine for you. 
 
We are looking forward to hearing from you.
 
Best Regards,
Vera

Please login or Register to Submit Answer