Hello,
We noticed that when we have two calculated values, one depending on the other to avoid division by 0, the dependent calculation shows Infinity
when it should not. We have prepared a jsFiddle for ease of replication.
Independent
which is defined as the following calculation: if(sum(\"Price\") = 0, 0, sum(\"Quantity\") / sum(\"Price\"))
Dependent
which is defined as the following calculation:if(\"Independent\" = 0, 0, 1 / \"Independent\" )
Price
and Quantity
as columns to verify the calculationsDependent
value is Infinity
despite the calculation of Independent
not working out to be 0. However,
Independent
as a column such that i appears before the Dependent
column, we can see that the Dependent
values are updated to their correct valuesIndependent
as a column such that it appears after the Dependent
column, we can see that the Dependent
values are still Infinity
Please let us know if there is something wrong with the jsFiddle or if we can provide any additional information!
Kind regards,
Henry
Hello, Henry,
Thank you for reporting the issue.
It seems this behavior is only reproducible when using the custom data source API. It is due to some particular properties of the protocol.
We will research possible solutions for this issue and provide you with results ETA Aug 10.
Please let us know if other questions arise.
Kind regards,
Illia
Hello, Henry,
We are happy to let you know that the issue with dependent calculated values was fixed.
This is included in the 2.9.5 version of Flexmonster: https://www.flexmonster.com/release-notes/.
You are welcome to update the component.
Here is our updating to the latest version guide for assistance: https://www.flexmonster.com/doc/updating-to-the-latest-version/.
Please let us know if everything works fine for you.
Best regards,
Illia
Hello, Illia,
Upgrading to 2.9.5 looks to have fixed the issue. Thanks much to you and the team!
Kind regards,
Henry