Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a scenario where in I have to get closing balance of previous month as opening balance for current month...
Ex: Apr closing balance is 2000 and May Closing balance is 3000 and so on..
So the opening balance for May should be 2000 and June should be 3000 and so on..
Can someone help me with this?
Note: I do not want to use ABOVE function as it has restrictions which doesn't meets my requirements. Apart from that I have also tried the below set analysis but it returns the value only for the particular month not all the months:
sum({<Month={'$(=Month(addmonths(max(Date),-1)))'}>}Sales)
Thanks in advance
Regards,
Puneet
To make non selected Months to be 0