Change grid column to affect sum - custom aggregate

[david]

     In itemDataBound I am conditionally changing an integer column, but the sum aggregate footer reflects the original values from the query. How do I get the changed value reflected in the sum?

 

[Attila Antal]

Hi David,

When a certain data is bound to RadGrid rows, that data will be processed later to calculate aggregate values as well. By changing the Text property of a Cell will not be bound to the Cell nor will be included in the aggregate values. It is like changing a variable name will not change the value assigned to it.

Having that in mind, if you are manually changing the data, you might as well update the aggregate values manually.

I happen to have an example of manipulating the aggregates by calculating only selected rows' values. Check and download the attachment.

In your case, you will need to update the aggregate values similar to the example. 

I hope this will prove helpful.

Regards,
Attila Antal
Progress Telerik

[david]

Thanks!