How to calculate difference between columns dynamically?

[bui195]

I'm trying to build a dynamic workflow that can calculate the difference between 2 months. I don't want to use Formula because the column names will change month by month. I'm using transpose and multi row formula but haven't been able to convert it back to the way I want. Below is the current input:

And this is my desired output. My current issue with the multi row formula is it keeps calculating the variance for previous month by repeating the October value in MoM Variance column. 

TIA

[binuacs · Accepted solution]

@bui195 One way of doing this

[FinnCharlton · Accepted solution]

Hi @bui195 , here is one way to do this:

[Gautam_Iyer · Accepted solution]

Here is one way to achieve it.

[bui195]

Thank you for your reply! When I apply your method into my actual data, I have an issue at the Multi row formula that it calculate the difference in the 10-31-2022 row too. It actually repeats the October value (335789) in the MoM difference column instead of showing 0. Any ideas how to fix that issue?

[binuacs]

@bui195 Can you screen shot your multi-row tool configuration? 

[bui195]

This is the configuration:

This is the outcome I currently see (I cut out the GL and client ID) but you can see it repeats the value for October:

[apathetichell]

deleting my comment - back to the peanut gallery and the capable workflow builds of the rest of the crew...

[bui195]

---

---

I actually figured it out. I missed the "Values when rows don't exist". I should have changed to Null. It works now. Thank you so much!!!