Incorrect Totals for calculated values

Hello Amogh,

Thank you for contacting us.

You are right that the totals of the calculated measure are calculated using the formula as well. Currently, Flexmonster only supports totals based on the same formula, not on the sum of the values.

However, the request to define separate aggregations for totals is already included in our Customers' Wishlist. Our team will notify you about any updates on the matter.

You are welcome to contact us if other questions arise.

Kind regards,
Nadia

Hello, Amogh,

Thank you for reaching out to us.

At the moment, built-in support for using a different aggregation for Grand Totals (separate from the calculated measure formula) is planned for version 3.0. You can track the progress on our public roadmap here:
https://prerelease.flexmonster.com/roadmap

As a workaround, we suggest using the getData API call to retrieve the data and the customizeCell method to modify the totals. The getData method can retrieve data from the current data source, but with a different slice, allowing retrieval of the totals calculated by a different formula or aggregation. This method reloads the data when the report is loaded and changes. When the data is retrieved, the customizeCell method can be used to set the total values in the corresponding cells.

Additionally, you can observe the slice changes using the reportcomplete and reportchange events, so that report changes (like applying a filter) will be passed to the slice used in getData.

We have prepared the example illustrating this approach: https://jsfiddle.net/flexmonster/t49o8520/

Please note that this approach has some limitations:

• It may impact performance since additional getData requests are required.
• It can require extra handling for certain slice changes to keep the values in sync with the grid.
• Values set via customizeCell are not formatted, so formatting should be applied manually.

Feel free to contact us if more questions arise.

Best regards,
Maksym