Accumlated Fiscal start to current month Set Analysis

Tue, 27 Aug 2013 08:14:43 GMT

hi .

I am trying to create an accumulated value.

I have a fiscal year 2013/2014.

Start Month is May.

I wish to select the fiscal year i.e 2013/2014 and Month Jul and return the values between May - Jul for 2013/2014.

i have the following statement but it is not working currently.

Any help greatly appreciated.

Sum(

{$< FYear={"$(=Dual(Max(fYear)-1 & '/' & Max(fYear), Max(fYear)))"}>}

FMonth={"<=$(==Max( {<fYear={$(=Max(Year))}>} Month))"}

Sum(Amount)

Best

Brad

topic Accumlated Fiscal start to current month Set Analysis in QlikView