Calculate Difference between values (current/prior and % diff)

[tiverson]

I have a data output where it adds a column when a new period is opened.

I want to calculate the difference between the prior  month and the current month, then calculate the % difference.

Is it easier to have a data input for the current period, then build logic to return that value....and the column 1 month prior?

Or how could I designate data that is from the current period vs prior period and do calculations from that?

Data

Desired Output 

Thanks for any help!

[Raj]

@tiverson are you looking for the formula to get the output for this file or do you want the logic to make this a dynamic thing?

[binuacs]

@tiverson one way of doing this

[tiverson]

@Raj , I would like to make it dynamic

[tiverson]

@binuacs , It looks like I have an older version of Alteryx and my company won't let me update it.  Is there another way I  open this workflow?

[binuacs]

@tiverson open the workflow in a notepad++ and change the version number to match your version number save and open again

https://community.alteryx.com/t5/Engine-Works/Making-Workflows-Apps-amp-Macros-Backwards-Compatible/...