Rolling 5 Quarters

[dunnalahk123]

Hi,

I need to take always 5 rolling Quarters in my data.

first variable i created is to get latest quarter

=Chr (39) & Maxstring( {<ScenarioLabel={'Actuals'}>} Quarter) & Chr (39)

Which gives me 2018-Q1

then i did as below

=$(vMaxQuarterRolling) - 10 to get 2017-Q1

but i am not getting that value. is it some thing i did some mistake , can some one help me here pls.

Best Regards,

Hk

[YoussefBelloum]

Hi,

do you have a master calendar on your model ?

[raajaswin]

Hi Hk,

create a column in script with

keepchar(columnname,'0123456789') as YR_QTR_NUM

now you will have numbers with you

then get last five quarter with with max(YR_QTR_NUM,1) ,max(YR_QTR_NUM,2) , max(YR_QTR_NUM,3), max(YR_QTR_NUM,4), max(YR_QTR_NUM,5)

[Anil_Babu_Samineni]

MaxString is not the solution your case, Even thought this can be done i assume you may need AddYears()?

[dunnalahk123 · Accepted solution]

HI,

I Wrote as below

=MID($(vMaxQuarterRolling) ,1,4)-1 &'-' & MID($(vMaxQuarterRolling) ,6,2)

Best Regards

Hk

[Anil_Babu_Samineni]

do you really think, Does this job done? Because, For me not make sense. Instead i would suggest you to do script level to bifurcate each and level.

Anyway, you got work. That is awesome !!!