Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

‘Wrong formula format’ error after upgrade to 2.8

Answered
Daniel Stokes 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!

5 answers

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster 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

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster 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

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster 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

Public
Daniel Stokes 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

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster 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

Please login or Register to Submit Answer