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

New Altair Community Member

Updated Nov 5, 2024 by Jocelyn

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

Sort by:

1 - 1 of 11

Altair Employee

Accepted Answer

Hi,

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

Best,

Martin