Opening Balance Problem

[rohitians]

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

[jagan]

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.