Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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