Hi guys,
I have a grid with amounts for each month of the year which has totals for rows and columns. I use aggregates for column totals and a javascript function for the Totals column and the grand total.
This works nicely when a user edits a row. When he comes out of edit mode the totals are recalculated properly.
Now comes the problem. We have a change values functionality which allows the user to setup a pattern for changing values, eg: decrease by 10 percent where amount > X. I cannot use .set(value) for setting the amount since the grid sometimes has 7 pages and calling that for many cells has a huge performance impact.
So how can I have all aggregates recalculated at the end of my function execution?
I'll mention that changes are batched and saved only when user presses the Save button.
Thank you,
Mircea D.