asked on December 6, 2023
Dear Flexmonster team,
I am currently helping my client Rauscher & Stoecklin with an overview which has been implemented with Flexmonster. It's a grid chart showing a "gebuchte Slots" (reserved production slots) and "geplant in APP" (booked production slots) per client.
The grid chart is using Sum(Anzahl), which is summing up the number of products per day per client in order to deliver a cumulated result for the two categories for "reserved production slots" and "booked production slots". Now, the cumulation of these categories does not make sense for the monthly number, but it should rather be a subtraction. Reserved production slots - booked production slots = still available production slots would be the correct monthly result.
Is it possible to change the maths operator (from sum to difference) on the highest level in order to achieve this?
Thanks a lot and best regards,
Markus Püttner
⋅ December 8, 2023
Hello Markus,
Thank you for the question.
Currently, Flexmonster provides setting only one aggregation for all levels. As a workaround, you can hide the totals columns by setting the grid.showTotals property of the Options Object to false. You are welcome to check the following JSFiddle for reference: https://jsfiddle.net/flexmonster/jypdza6w/.
Feel free to contact us in case other questions arise.
Kind regards,
Nadia
