Subtracting values from same column into new column

limats

Hi All,

I am trying to subtract values that are in a column i.e. subtract values from the row above for all the rows. I would like to also show the percentage change per row. I have the following input and wish to get the desired output as shown exactly below. Please can someone advise? 

Many thanks in advance

Input 

Date	Amount
4Q14	1000
1Q15	800
2Q15	600
3Q15	1200
4Q15	950
1Q16	700
2Q16	800
3Q16	700
4Q16	500

Desired Output

Date	Amount	Change	% Change
4Q14	1000	n/a	n/a
1Q15	800	-200	-20
2Q15	600	-200	-25
3Q15	1200	600	100
4Q15	950	-250	-21
1Q16	700	-250	-26
2Q16	800	100	14
3Q16	700	-100	-13
4Q16	500	-200	-29

atcodedog05

Hi @limats 

Here is how you can do it. You can do this using multi-row formula tool.

Workflow:

Interactive lesson on Multi-row formula tool:

https://community.alteryx.com/t5/Interactive-Lessons/Multi-Row-Formula/ta-p/82872

Hope this helps : )

% Change.yxmd