asked on July 16, 2024
Goedemiddag,
Is het mogelijk om te werken met de conditionele formatering waarbij het rapport alleen maar kijkt naar de totaalwaarde van een som. In bijgevoegd bestand wil ik dus graag dat alleen de totalen van alle betaalmethodes welke groter zijn dan € 100,--, rood worden gearceerd.
Ik verneem graag van jullie.
Alvast bedankt.
⋅ July 17, 2024
Hello, Joris!
Thank you for reaching out to us.
The described functionality with disabling the conditional formatting for non-grand total cells can be achieved by using the customizeCell API call. This method allows the customizing of separate cells by passing a JS function. This function would receive a cell builder object through which the cell can be modified and the cell data object containing the information about the cell. By using isGrandTotal property of cell data, you can identify which cells are not in grand totals and override their styles to match the appearance of non-highlighted cells. You are welcome to check the JSFiddle example: https://jsfiddle.net/flexmonster/0p9Lrfx1/
Also, you can use the isTotal conditional format option, which is accessible from our API. When this parameter is true, the formatting will be applied to totals and subtotals. This is different from the previously described approach, where the highlight is also removed from subtotals. We also prepared an example illustrating this approach: https://jsfiddle.net/flexmonster/ocgdbv0j/
Please let us know if the described approach works for you.
Best Regards,
Maksym
⋅ August 13, 2024
Hello, Joris!
Hope you are doing well.
We wonder if you have time to check the provided solutions for applying conditional formatting only for totals.
Looking forward to hearing your feedback.
Best Regards,
Maksym
⋅ September 3, 2024
Hello, Joris!
Just checking in to ask whether you tried our solutions for using conditional formatting only with totals.
Please let us know if one of them worked for you.
Best Regards,
Maksym
