Altair RISE

A program to recognize and reward our most engaged community members

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

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

AI Studio

Hi,

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

Best,

Martin

Hi,

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

Best,

Martin

mschmitz Thank you!