Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
How can I pass financial year in to below set analysis instead of year?
sum( {$<YEAR = {$(#=Only(YEAR)-1)}>} Qty )
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