Appending calculated rows in a table problem

[ajit555]

Found one compact solution using “Column Expression” Node.

Calculated-Rows-Table.knwf (97.6 KB)

Facing below problems:

1. For calc3 column, first row, I need to convert null value to zero to evalue it to “43” instead of null.

I have requested for some solution here:

Converting null to zero in "Expression" and "Column Expression" node.

Hello, Could you please help in modifying the expression where the null values can be converted to O (zero) in the expression itself (using if … else or anything else) ? Column-Expressions.knwf (77.0 KB) How to convert the null value to zero using expression for the below nodes: “Prev_c1” column, first row, null value should be 0 (zero) [image] “Prev_c1+c2” column, the first row, the value should be 10 instead of null [image] How to compute the same (“Prev_c1” & v"Prev_c1+c2" columns…

2. In the “Column Expression” node, I can not define “calc5” column which uses “calc4” column. I need to define another “Column Expression” node to use the calculated columns.