Fiscal Year Set Analysis Previous year

[#1]

hi i have the following format

2012-2013 on fiscal year

i would like to create a set analysis expression based on fiscal year

i have tried the following without success ;

sum( { $<FiscalYear = Year={"$(=max(Year)-1 & '-' & max(Year)-2"))}>}OrderAmt

any help is greatly appreciated.

Best

Brad

[abeyphilip]

Hi,

Check if this help:

sum({<Year={"$(=$(vYear1)&'-'&$(vYear2))"} >}OrderAmt)

with two variables:

vYear1 = max(Year)-1

vYear2 = max(Year)-2

Regards,

Abey

[pgrenier]

Hello Bradley,

I believe this might come in handy:

Sum({<FiscalYear={"=(Max(Year)-1)&'-'&(Max(Year)-2)"}>} OrderAmt)

Cheers,

Philippe

[#4]

Thank you for your advice.

unfortunately i need a statement that is dynamic so that is  i can get the previous calender year as well.

for example if i if i choose 2013-2014 i would like to see 2012 -2013 in the column beside 2013-2014.

example

Sum({<FiscalYear={"=(Max(Year)-1)&'-'&(Max(Year)-2)"}>} OrderAmt)

Sum({<FiscalYear={"=(Max(Year)-2)&'-'&(Max(Year)-3)"}>} OrderAmt)

i have tried with increasing minus values to 1 in the statement but to no avail.

any tips

Best,

Bradley

[pgrenier]

I see,

I believe you shall have to parse the contents of the current selected FiscalYear, and work with that. Would you mind giving this statement a try?

Sum({<FiscalYear={"=(Left(FiscalYear, 4)-1)&'-'&Left(FiscalYear, 4)"}>} OrderAmt)

Cheers,

Philippe

[chematos]

With $(=max(Year)-1 & '-' & max(Year)-2), don't you get 2012-2011 instead of 2012-2013?

Also, I think you need simple quotes to get '2012-2013' and compare with FiscalYear

try this:

sum( { $<FiscalYear ={'$(=(max(Year)-1) & '-' & max(Year))'}>}OrderAmt)

Hope this helps

Regards

[Clever_Anjos · Accepted solution]

I think

sum( { $<FiscalYear = Year={"$(=max(Year)-2 & '-' & max(Year)-1"))}>}OrderAmt)

should be the correct

[anna_elle]

Hey Philipe,

I tryed all your smart suggestions, without success.

The issue is that once I set the quotas, the funktions are recognised as a string:

I created the fiscal year by using the Funktion "yearName" , the format of the output is a date and is shown as 2012-2013. 

Do you know what the solution could be?

Many Thanks,

Anns