3
Hello, I would like to know how to calculate the price variation from one period to another. Being several years for several companies. Example:
Company | Year | Price
1 |2007 | 25
1 | 2008 | 30
1 |2009 | 7
1 |2010 | 15
2 |2007 | 20
2 | 2008 | 27
2 |2009 | 7
2 |2010 | 20
... |... |...|...
The new column would be:
Company | Year | Price | Variation
1 |2007 | 25 | 25-0 = 25
1 | 2008 | 30 | 30-25 = 5
1 |2009 | 7 | 7-30 = -23
1 |2010 | 15 | 15-7 = 8
2 |2007 | 20 | 20-0 = 20
2 | 2008 | 27 | 27-20 = 7
2 |2009 | 7 | 7-27 = -20
2 |2010 | 20 | 20-7 = 13
... |... |...|...
I have no idea how to do this.
would use the diff?
Thanks in advance !
It worked, thank you !
– RxT