Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
250
Exclude a row from Column Summaries
posted

Hi,

 We have the situation where we are showing a sum of all the currency amount in a particular column. The user can 'delete' a row though (the row is still in the data source - it is just marked as deleted with a strikethrough font). Since the row is still in the datasource, it's value is still calculated in the summary. Is there any way I can exclude a row from the summary?

 Thanks,
Colin.

  • 469350
    Verified Answer
    Offline posted

     Hi Colin,

        You could use a custom summary by implementing ICustomSummaryCalculator. This would allow you to calculate the summary any way you want.

        Another alternative would be to add an unbound column to the grid use InitializeRow to copy the "real" value into this hidden column, then sum the hidden column. That way you could leave out the deleted values.