Refill column with calculation. Can I use the moving average node?

[Frank2323]

Hello,

I have an empty column called ‘base’ and I want to refill this column with a calculation. Only the first value ‘155’ is given. I want to refill for example cell C3 with this formula C3=C2+D2+E2

Can I use the moving average node for that? Thank you.

[Iris]

Hi Frank,

this was the same question you did ask here: Knime Calculation. How can I use a value from the row before for a calculation.

Where the answers not helpful?

Best, Iris

[Frank2323]

Hey Iris, yes the answer was helpful. But in the other question, I calculated C3 = C2+D3+E3 and know I need C3=C2+D2+E2. Can you see the difference? So I use now the row before. So, which settings do I need?

[HansS]

Hi @Frank2323

As @Iris mentioned above, she already solved a similiar question from you in Knime Calculation. How can I use a value from the row before for a calculation. The solution for this question is more or less the same. Just add a Lag Column node to the flow and you’re done. calculate_next_next.knwf (25.9 KB)
gr. Hans

[Frank2323]

Thanks a lot.