Hi all How can I do some rolling calculations ? The ideia is to get something like the following table
Data1 | Data2 | DataVal | calculated |
row1 | x | 1 | 0 |
row2 | y | 3 | calc(row2)=dataval(row1)-dataval(row2) |
row3 | z | 4 | calc(row3)=dataval(row2)-dataval(row3) |
row4 | c | 7 | calc(row4)=dataval(row3)-dataval(row4) |
Thanks !