How to replace the row's value by the original value minus the previous row's value?

iven

For example, the first row is 1,2,3. the second row is 4,6,8.
And I want to change to the first row: 1,2,3. The second row: 3,4,5

MartinLiebig

Hi,

use lag first and then you can use generate attributes to substract.

Best,

Martin

iven

mschmitz Thank you!