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) using “Column Expression” node [image]

Column-Expressions.knwf (76.8 KB) Problem solved after incorporating the above two solutions. Thank you so much.

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

mlauber71 August 23, 2024, 8:56am 4

You will have to activate multi-row access

2 Likes

FIFO stock calculation