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.
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?
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?
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)
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.