Sum from row value, “2 colums” the max handsontable

Tags: #<Tag:0x00007f8b23eba810>

I have a handsontable where I need to sum cols, the end col has total from all cols summed I can sum all cols, the problem is cols is dynamics sometimes one-col has a child, in this case, I need to sum the max of both, but I don’t know how can I do it, !when is just one just sum one. if has a child sum just the max both cols.!

ex: work1 is the parent. the child is help 1 , the arrays cols came from database

example http://jsfiddle.net/duxL728h/
image
image

Hi @goou1821,

You can use data as a function in columns definitions: https://jsfiddle.net/handsoncode/1sn07khw/.

It will recalculate the cell value in the total column each time you change something in a row.

1 Like

thanks so much!!!