Opening Balance Problem

rohitians — Wed, 17 Apr 2013 09:52:53 GMT

Hello,

I have closing balance of march 2012 i.e it would be opening balance for april 2012 financial year, i have the following logic using

IF(Rowno()=1,vOPBAL,Above(Column(previous one)))

vOPBAL=(SUM({$<FinancialYear=,MonthName=,[Posting Date] ={'31/03/2012'}>}[Opn Doc Amt])

This works fine for the year 20113,

but for the year 2013 it again takes the closing balance of march 2012 whereas it should take closing balance of march 2013.

Please help...

I am attaching an excel file for better understanding....

Thanks and Regards,

Rohit

Re: Opening Balance Problem

jagan — Wed, 17 Apr 2013 11:42:02 GMT

Hi Rohit,

You have hardcoded the date in your variable it should be dynamic,

vOPBAL=(SUM({$<FinancialYear=,MonthName=,[Posting Date] ={'$(=MakeDate(Max(Year), 3, 31))'}>}[Opn Doc Amt])

Hope this helps you.

Regards,

Jagan.