We upgraded our version of Flexmonster from 2.7.19 to 2.8.14, and now get an error when trying to create a calculated field.
Previously, we were able to create Calculated Values with no problem. However, now we get an error like:
“Wrong formula format. Please check.
The aggregation ‘sum’ in the ‘Average Ticket Price’ formula is not valid.”
We see this for any calculated field, even if we only add one measure. See the attached screenshots for an example.
Was there a change between the two versions which might be causing this issue? Any suggestions on how to resolve it?
Thank you for reporting the problem.
The fix is going to be provided with a minor update ETA Oct 19.
We will notify you as soon as the version with a fix is available to download.
As a temporary workaround, we recommend disabling the formula validation using the
options.validateFormulas property. Define its value as false to disable the alert. The calculated value will be created as expected.
Please contact us in case any other questions arise.
We are happy to let you know that the issue with formula checker was fixed.
This is available in the 2.8.18 version of Flexmonster.
You are welcome to update the component.
Here is our updating to the latest version tutorial for guidance.
Please let us know if it works for you.
We want to kindly take an interest in whether the recent fix resolved the issue.
Our team is looking forward to hearing from you.
My team will be updating our version of Flexmonster in our next sprint, so I’ll be able to give an update once that’s done. It’ll be within the next two weeks.
Our team is wondering whether you had some time to test the recent fix.
We are looking forward to hearing from you.