asked on February 23, 2024
Hello
Total SUM is wrong.
Added total value screenshot and details when clicked on sum value.
What could be wrong here?
⋅ February 23, 2024
Hello Juhan,
Thank you for reaching out to us.
We could not reproduce the described behavior on our side. Could you please provide us with the dataset where the issue is reproducible? It would greatly help us.
Looking forward to hearing from you.
Kind regards,
Nadia
⋅ March 5, 2024
Hello Juhan,
Hope you are doing well.
We were wondering if you are still experiencing the issue. If the issue persists, please provide us with the dataset that demonstrates the issue. It would be really helpful.
Looking forward to hearing your feedback.
Kind regards,
Nadia
⋅ March 5, 2024
Hey
I can't figure out what's wrong in my setup.
Quick export data to xml -> json and jsfiddle gives the right output. But in my application the calculation is wrong, with the same data.
⋅ March 6, 2024
Hello Juhan,
Thank you for the response.
Our team supposes that the specific configurations of your application environment may cause the issue. We recommend verifying that the raw data is being accurately passed to Flexmonster. Also, which data source do you use? It would greatly help us.
Looking forward to hearing from you.
Kind regards,
Nadia
⋅ March 6, 2024
Hello
I'm using mysql index created in Flexmonster admin panel.
The numbers are correct in drilldown, but the sum is wrong :/
⋅ March 8, 2024
Hello Juhan,
Thank you for providing us with details.
Kindly note that by default, the drill-through view shows only the first 1000 rows for the "api" data source type. You can set the drillThroughMaxRows property of the options.grid object to 0 to show all the rows.
Please let us know if it works for you. Looking forward to hearing from you.
Kind regards,
Nadia
⋅ March 18, 2024
Hey
The problematic row has 78 results. In drilldrown i can see all the results and numbers, but the sum is wrong.
If i filter the table to show only the problematic row group, the sum is correct.
If i look at unfiltered table(2660 rows total)- then the sum is wrong.
⋅ March 20, 2024
Hello Juhan,
Thank you for the details.
Based on the provided details on the issue and the fact that it cannot be reproduced on JSFiddle, we suppose that the incorrect sum is caused by some configuration in your project.
To identify which part of the code is affecting the sum, we suggest turning off all Flexmonster configurations and then enabling them one by one to detect which part is causing the issue. Specifically, it is recommended to check if there is any customizeCell function that might be overriding the value of the cell.
Please let us know if it helps. Looking forward to hearing from you.
Kind regards,
Nadia
