topic Re: Show previous month data on current month selection in App Development

Show previous month data on current month selection

skzwane01 — Sat, 16 Nov 2024 00:16:59 GMT

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

Re: Show previous month data on current month selection

jwjackso — Thu, 08 Apr 2021 20:58:52 GMT

You can calculate the [Opening Balance] as Above ([Closing Balance])

Re: Show previous month data on current month selection

skzwane01 — Fri, 09 Apr 2021 07:30:36 GMT

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: