Subtracting Between Columns

[wpatino15]

Hello,

I'm fairly new to Alteryx and I'm trying to get the hang of it. I'm currently working on a workflow and need some assistance.

So what I am currently doing is trying to see increases of data between years. Below is how the data looks:

Type          2012    2013    2014    2015   2016    2017

Average      78       76         88       110      129     157

What I want it to do is to find the difference for each of those years, but if the amount goes down, to show me a zero. So I want the data to look like this:

Type          2012    2013    2014    2015   2016    2017

Average      78       76         88       110      129     157

Change        0         0          12        22        19       28

Any assistance in this would be highly appreciated. Thank you in advance!

[ponraj · Accepted solution]

Attaching a sample workflow for you case. Hope it is helpful. 

[wpatino15]

That solved my problem. Thank you so much for your help!