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 |
Solved! Go to 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 : )
That worked. Thank you so much!
Happy to help : ) @sshahid96
Cheers and have a nice day!