Divide cells in column using value of another column

[pgrachellod]

Hi,

I have data for X article for 2017 and 2018:

I want to do the following calculation

2018 Result = Y / 2017 X

Any suggestion how to do it?

Thank you!

[mlauber71]

You might have a look at this. The main component ist the Lag Column (https://nodepit.com/node/org.knime.base.node.preproc.columnlag.LagColumnNodeFactory). Yo you can access other lines. You could expand this further to make sure it only takes the previous vale if it is the same book or a specific year, or make it universally usable for different years. Just to illustrate the principle.

kn_example_lag_books.knwf (38.9 KB)

[pgrachellod]

Hi @mlauber71,

Thank you so much! It is what I needed! Work perfectly.

Best,
Paola