briangriffin
Programmer
If possible, I'd like to calculate the differences between every two rows (bold rows to be added):
9/2022 1000
9/2021 900
Variance 100
10/2022 1000
10/2021 1200
Variance (200)
I'm guessing I would use lead/lag and some kind of loop, but if anyone has something similar I'd be very interested to see how you did it. TIA.
9/2022 1000
9/2021 900
Variance 100
10/2022 1000
10/2021 1200
Variance (200)
I'm guessing I would use lead/lag and some kind of loop, but if anyone has something similar I'd be very interested to see how you did it. TIA.