asked on July 28, 2023
Hi team,
we detect an important issue in sum column. I.E.
If we extract 2 simple column ( description / sum of a misure ) we detect a value in SUM but if we filter a specific description we detect a different sum. See attached file
Please help us to resolve and fix the problem
Angelo
⋅ August 1, 2023
Hello, Angelo!
Thank you for reaching out to us.
Our team could not reproduce the described behavior on our side. Could you please modify our JSFiddle so the issue is reproducible: https://jsfiddle.net/flexmonster/g0Lj12zh/.
This would help us greatly to continue the investigation.
Looking forward to hearing from you.
Kind regards,
Solomiia
⋅ August 9, 2023
Hello, Angelo!
Hope you are doing well.
Our team is wondering if you had some time to modify the provided JSFiddle and make the described behavior reproducible.
With this information, we will be able to continue the investigation.
Looking forward to hearing from you.
Kind regards,
Solomiia
⋅ August 10, 2023
Hi,
we solved the issue executing an UPPERCASE on that specific field via MySQL query. Maybe flexmonster doesn't works fine with mixed lower and upper characters in fields.
You can close the ticket
Ciao
⋅ August 10, 2023
Hello, Angelo!
Thank you for your feedback.
We are glad to hear the issue is resolved now.
We also want to kindly note that by default, the field names in Flemxonster are not case-sensitive. However, you can enable the case-sensitive hierarchies using the caseSensitiveMembers option:
report: {
options: {
caseSensitiveMembers: true,
//other options
},
//other report configurations
}
We have prepared a JSFIddle sample for illustration: https://jsfiddle.net/flexmonster/56m7h1Lt/.
Hope you will find our answer helpful.
Kind regards,
Solomiia