Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I need to make a ratio in a rolling12 seta nalysis between first value of the range (newer) and the last one (older)
Any idea to do that?
Many Thanks for your help
Bruno
Sum
({Real*$(vMeasure)* $<MonthID = {">=$(=Max(MonthID) - 11)<=$(=Max(MonthID))"},
Date = {"<=$(=Max(Date))"},
Year =,
Quarter = ,
Period = ,
[Period (#)] = ,
Month =
>}QTD)/Above(
Sum
({Real*
$(vMeasure)* $<MonthID = {">=$(=Max(MonthID) - 11)<=$(=Max(MonthID))"},
Date = {"<=$(=Max(Date))"},
Year = ,
Quarter = ,
Period = ,
[Period (#)] = ,
Month =
>}QTD))
I found solution.
This is the best way?
Thanks
Bruno
=
Sum
({Real*$(vMeasure)* $<MonthID = {">=$(=Max(MonthID) - 11)<=$(=Max(MonthID))"},
Date = {"<=$(=Max(Date))"},
Year =,
Quarter = ,
Period = ,
[Period (#)] = ,
Month =
>}QTD)//Sum({Real*$(vMeasure)* $<MonthID = {"$(=min({Real*$(vMeasure)* $<MonthID = {">=$(=Max(MonthID) - 11)<=$(=Max(MonthID))"},
Date = ,
Year =,
Quarter = ,
Period = ,
[Period (#)] = ,
Month =
>}MonthID))"},
Date = {"<=$(=Max(Date))"},
Year =,
Quarter = ,
Period = ,
[Period (#)] = ,
Month =
>}QTD)