how to move a value into adjacent row

[crmarley20]

Hello,

I have a condition when the variable new_tag of the previous row is equal to 1 and the variable test_tag of the current row is equal to 1 I must subtract the start value of the previous row with the start value of the current row.

I want the result of the subtraction to be written in the previous row in the result column.

Unfortunately I could only get this subtraction to be written to the current row in the result column.

Please could someone help me, thank you very much.

[ITWhisperer · Accepted solution]

| reverse
| streamstats window=2 first(result) as result
| reverse

[crmarley20]

Thank you very much!