In JMP we can do calculation using the JMP calculator.

The parameters in the formula are the columns table, attached is a simple formula subtracting y column from x column with LAG,

What I want to know is if there is a way to use different lag for different rows.

((Lag( x, 2 ) - :y) / Lag( x, 2 )) * 100

Thank you

Yaakov