asked on September 17, 2020
Hi,
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!
⋅ September 17, 2020
Hello,
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.
Kind regards,
Illia
⋅ October 20, 2020
Hello, Daniel,
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.
Best Regards,
Illia
⋅ October 26, 2020
Hello, Daniel,
We want to kindly take an interest in whether the recent fix resolved the issue.
Our team is looking forward to hearing from you.
Kind regards,
Illia
⋅ October 27, 2020
Hi Illia,
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.
Regards,
Dan
⋅ November 16, 2020
Hello, Daniel,
Our team is wondering whether you had some time to test the recent fix.
We are looking forward to hearing from you.
Kind regards,
Illia
