Calculate Monthly Variance

[sshahid96]

Hi, 

I have a data set that is grouped by a Unique ID and Month. I would like to the Total Balance and Average Balance fields to display the difference between the two months. Please see example below. 

Input: 

ID	Month	Total Balance	Average Balance
01	May	5,000	2,000
01	June	7,000	6,000

Desired Output: 

ID	Total Balance	Average Balance
01	3,000	4,000

[atcodedog05 · Accepted solution]

Hi @sshahid96 

Here is how you can do it.

Workflow:

1. Using multi-row formula to calculate abs([previous row] - [current row]). Abs is used to take positive value

2. Using summarize tool to take last row value with variance.

Hope this helps : )

[sshahid96]

That worked. Thank you so much! 

[atcodedog05]

Happy to help : ) @sshahid96 

Cheers and have a nice day!