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
45
Excluding fixed rows in formula
posted

I have added a blank row in top of the grid, which is fixed. I am using this to update all rows on cellchange. My problems are

 - I want to exclude this top row from count in calcmanager formula

-  I want to exclude this top row from sum in calcmanager formula

- Need to put an if condition to sum and count only checked rows (there is a checkbox column"select" )

Please suggest me, may i achive this useing WinCalcManager.

Thanks

Parents
  • 469350
    Verified Answer
    Offline posted

    There's no way to exclude asingle row like this from a CalcManager calculation. What you could do, though, is add a hidden, unbound column to the grid and populate this column with values copied from the "real" column, and just leave the one cell blank. Then perform your calculations on the hidden column so that the fixed row value is left out.

Reply Children