Variable to give me Current Financial Year -1

[#1]

I need to create a variable which will hold the current selected Financial Year - 1

I have a variable to hold the current Financial Year  =if(isnull(FinancialYear),yearname(today(), 0, 4 ), FinancialYear)

However I cant seem to find one which will give me the current selected FY - 1

The following does not work -=if(isnull(FinancialYear),yearname(addyears(today(),-1),0,4), vCurrentFY )

Anyone have any ideas?

Many Thanks

[#2]

See attached. It takes the max year (either max selected if a year is selected or max of all data if no selection is made) and subtracts one year.

[#3]

Thanks for the post, however I need [Financial Year] and not Year

My [Financial Year] field = yearname (Date, 0, 4 )  as FinancialYear,

When I create the variable - max(FinancialYear) the output is '41000'

[whiteline]

When I create the variable - max(FinancialYear) the output is '41000'

Hi

Just change the format with date() function.

[#5]

yearname(today(), 0, - 4 ) which will give you the current selected FY - 1.Is this You want

[#6]

I already have the current selected FY  =yearname(today(), 0, 4 )

I need the current selected FY -1

So if I select '2012-2013', I need the variable to read '2011-2012'

And if I select '2011-2012' I need '2010-2011', etc...

This peice of code only gives me the last FY, regardless of my current selection

Thanks

[#7]

Please Find Attached the Document

[#8 · Accepted solution]

I used the following varible to the result... there may be an easier way to do it!

=yearname(if(isnull(FinancialYear),yearname(today(), 0, 4 ), FinancialYear), 0, - 4 )