Passing financial year!

[#1]

Hi All,

How can I pass financial year in to below set analysis instead of year?

sum( {$<YEAR = {$(#=Only(YEAR)-1)}>} Qty )

[#2]

Hi,

You will have to define Financial Year in a script.

Logic would be:

Say FY-Financial Year, Y-Year for Date-D (02-05-2010) and Month-M

IF M<=3,FY=(Y-1)---Y (IF D=02-03-2010,FY=2009---2010)

IF M>3,FY=Y---(Y+1) (IF D=02-05-2010,FY=2010---2011)

I hope I could convey you logic appropriately.

Happy Thoughts