We are trying to migrate to Flexmonster 2.9 and noticed an issue with a calculated value.
Steps to reproduce (see attachment for visual representation):
The cell on the intersection of January and 8 is still empty.
The cell on the intersection of January and 8 is 0.
Why do we get 0 when we basically divide empty/null value by 10 ?
Please note it works as expected for Version 2.310 (build 27/02/2017 14:26:19).
We believe we reported this bug many years ago. Some time in July 2012 according to our backlog.
Thank you for writing to us.
As the expected result for the mentioned aggregation depends on the use-case, we provide an option to configure the described above behavior.
Please use the
calculateNaN property of the calculated value object:
"uniqueName": "Formula #1",
"formula": "sum(\"Quantity\") / 10",
"caption": "Formula #1",
Here is an example for illustration: https://jsfiddle.net/flexmonster/e9qfuz03/.
Hope our answer helped!