calculation with row and column

KNIME Analytics Platform
1

Hello,

I would like to calculate the values per row of this equation :

(( yn+1 + yn )/2)*( xn+1 - xn )

but I have no idea.

Thanks in advance.

2

I assume by n, you mean row n?

if so,

use a lag column first on column x and column y, so you have two new columns x+1 and y+1.

then use the Maths Formula node by entering the formula described in your post, selecting the x, y, x+1, y+1 columns.

simon.

3

 Hello Simon,

Thank you very much for your answer. Your solution works very nicely :)