asked on December 14, 2021
Hello,
We are currently using the latest version of Flexmonster and we are experiencing an issue with the calculated values of a measurement when the option Format as percent is true as following.
The field "Alocação" is a calculated measure done like this:
if(sum('TotalHoursToAllocate') != 0, sum('TotalAllocatedHours') / sum('TotalHoursToAllocate'), 0)
As shown in the first image, the value is 1 as expected for the displayed rows when Format as Percent is false.
When the Format as Percent is set to true as in the second image, we get wrong decimal values which should not be showing. This happens only when loading a bigger json file.
Is there any way to fix this?
⋅ December 15, 2021
Hi Vinicius,
Thank you for posting your question.
So far, we weren't able to reproduce the issue on our side. Could you please send us your report configurations and a dataset (or their dummy equivalents) with which this behavior is reproducible?
Looking forward to your response.
Best regards,
Mykhailo
⋅ December 20, 2021
Hi Mykhailo.
The report object we are using is attached to this message.
As the dataset file is larger than 10mb, I've uploaded an equivalent response with dummy data to Google Drive in the following link:
https://drive.google.com/file/d/1pkXsKnjAMFfGgi-Fr-SxN8b6c30pSis_/view?usp=sharing
Regards,
Vinicius
⋅ December 21, 2021
Vinicius,
Thank you for providing your data set and report configurations – with their help we were able to reproduce the issue on our side.
Our development team will fix this behavior with our upcoming release on ETA Jan 10th.
Please let us know if there is anything else we can help you with in the meantime.
Best regards,
Mykhailo
⋅ December 21, 2021
Thank you for your quick response, Mykhailo. It's great that the team managed to reproduce it.
We'll wait until the fix.
Regards,
Vinícius
⋅ January 11, 2022
Hello, Vinicius,
We are happy to inform you that the issue with unexpected calculations when working with time measures was fixed.
This is available in the v2.9.16 (latest) minor release version of Flexmonster.
You are welcome to update the component. Here is our updating to the latest version guide for assistance.
Please let us know if the fix works fine for you.
Looking forward to your feedback.
Kind regards,
Vera
⋅ January 18, 2022
Hi Vinicius,
Hope you're doing well!
Just checking in to ask if you've had a chance to test out the fix provided in our latest release. Is everything working well?
We'd be happy to hear your feedback.
Best regards,
Mykhailo