calculating opening bal

[#1]

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.

[MK_QSL]

Can you provide little more information on how your calculated Closing balance?

[Jacek]

in expression Openning column : Above([sum(CLOSING_BALANCE)],1)

Above ( [name_source_column] , offset )

[chematos]

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

[#5]

Hello Jose,

Find attached what i got not working

[chematos]

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

[#7]

This is what i got

[chematos]

Check this

[#9]

Its not picking above for Jan 2015, that is an issue

[#10]

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