Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to capture previous value of my closing account as opening account for the next month . Find attach excel. Gives u clue.
Note opening balance should start wt zero.
Can you provide little more information on how your calculated Closing balance?
in expression Openning column : Above([sum(CLOSING_BALANCE)],1)
Above ( [name_source_column] , offset )
You should take a look to this:
Calendar with flags making set analysis so very simple
If you don't use the "AsOfCalendar", then try with the following solution.
Lets say you have a numeric DateID for each Date field in your calendar, you could use it in your expression.
Your expression for Opening Balance should be something like that, in case your closing balance is a data:
Sum({<DateID={'$(=DateID-1)'}>} Closing Balance)
If not, use this set analysis to replicate the calculations for current Closing Balance, in order to calculate the previous closing balance.
Regards,
Jose
Hello Jose,
Find attached what i got not working
change Date(Date) to Rowno() as DateID, make sure you have the dates ordered by ascendent.
Then, you can use for your chart Above() function to calculate Opening Balance:
Above([Closing balance])
Regards,
Jose
This is what i got
Check this
Its not picking above for Jan 2015, that is an issue
Hello Manish,
I want the Closing balance of the previous month to be the opening of the next as it is on the excel starting with zero