Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a dataset of employees per month. I have to create an opening balance expression which is: the closing balance of the previous month. Please see examples below:
Sept 2020 Closing Balance = 200
Oct 2020 Opening balance = 200 and Closing Balance is 250.
Nov 2020 Opening Balance = 250 and Closing Balance is 230.
Dec 202 Opening Balance = 202 and Closing Balance is 200
Hope this makes.
Your assistance is highly appreciated.
Kind Regards
You can calculate the [Opening Balance] as Above ([Closing Balance])
Thanks it works!!! It is actually the "Before" function.
How do I now show the first months data? If you look at the below example, 202011 has no value based on the current selection, how do I show the 202010 closing balance as the 202011 Opening balance?
The expression is as below: