How to convert set expression to become dynamic

[paulyeo11]

Hi All

Mr Kaushik Solanki help me with the below expression :-

      =money(if([Exec P&L Level] = 's','',Sum({$<YearMonth = {"<=$(=Date(addmonths(Max({$}[YearMonth]),-12),'YY MMM'))"}, month = >}[Amount])), $(vCurrency))

My question is how to make the above expression dynamic , meaning when i select month= jan year=2013 , it will display jan 2013 Balance sheet amount. ( now it does not allow user to select month and year , it just display max month and max year ).

https://www.dropbox.com/s/foqnz3kiddk995k/QV4FS_ver304%20ver%20009.qvw

Above link is my QV doc .

Paul

[kaushiknsolanki · Accepted solution]

Hi,

    Have a look at the attachment.

Regards,

Kaushik Solanki

[#3]

HI ,

I dont what was your Requirement .

try this

=money(if([Exec P&L Level] = 's','',Sum({$<YearMonth = {"<=$(=Date(addmonths(({$}[YearMonth]),-12),'YY MMM'))"}}[Amount])), $(vCurrency))

//Yusuf Ali

[paulyeo11]

Hi Kaushik

You are very good , you able to understand what i want. by adding just year in the expression it work fine.

Paul