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
603
Conditional Summaries
posted

I have a grid with A, B, and C columns on it and a summary item at the bottom of the last two columns. Right now all the values are being added up but what I want is to have the first bound column (boolean) determine if the B and C columns  are to be included in the summation or not. Any tip on how to implement this the most efficient way? Sample snippet will be appreciated.

Parents
  • 469350
    Offline posted

    Another option would be to add an unbound column (let's call it D) to the grid and hide it. You would then use the InitializeRow event of the grid to examine the value of of the other cells in the row and populate column D with a value (which might be 0 if column A if false). Then you could add a summary for Column D and position it under Column B, or C.

Reply Children