FIFO stock calculation

[mlauber71]

@4nak1n the new KNIME expression node can do that.

https://docs.knime.com/latest/knime_expressions_guide/index.html

$["column_name", -1] Value of the column “column_name” from the previous row

Also there is the lag column node and the Column Expressions node can also do this, you have to activate the function though:

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

You will have to activate multi-row access [image]

In your case you might have to use a loop or refer to the result if the calculation. Here is a discussion that might give some insights

Convert data input level (level 1, 2, 3) into tree (1, 1.1, 1.1.1, 1.1.2...)

Hi @christoph_knime , welcome to the KNIME community If you are happy to write some code, the Column Expressions node (in the KNIME Expressions extension) can derive this by cumulatively calculating the “tree”. var treeOutput // variable for cumulative tree calculation // define the column representing the current Level currentLevel=column("Level (Input)") /* define some support functions */ function getTreeToLevel(tree,level) { if (tree==null || tree=="") { return "0" …