Hello everybody!
I have this expression to have the accumulated values of 12months.
Rangesum (above(TOTAL SUM({1<_Año={$(V_ActualYear)},_MesNum={'<=$(V_Max_Month)'},Month=>}Sales),0,RowNo(TOTAL)))
+
IF(MonthNum=1,
SUM({1<Year={'$(V_LastYear)'},MonthNum={'>1'},Month=>}TOTAL Sales)
,IF(_MesNum=2,
SUM({1<Year={'$(V_LastYear)'},MonthNum={'>2'},Month=>}TOTAL Sales)
,IF(_MesNum=3,
SUM({1<Year={'$(V_LastYear)'},MonthNum={'>3'},Month=>}TOTAL Sales)
,IF(_MesNum=4,
SUM({1<Year={'$(V_LastYear)'},MonthNum={'>4'},Month=>}TOTAL Sales)
,IF(_MesNum=5,
SUM({1<Year={'$(V_LastYear)'},MonthNum={'>5'},Month=>}TOTAL Sales)
,IF(_MesNum=6,
SUM({1<Year={'$(V_LastYear)'},MonthNum={'>6'},Month=>}TOTAL Sales)
,IF(_MesNum=7,
SUM({1<Year={'$(V_LastYear)'},MonthNum={'>7'},Month=>}TOTAL Sales)
,IF(_MesNum=8,
SUM({1<Year={'$(V_LastYear)'},MonthNum={'>8'},Month=>}TOTAL Sales)
,IF(_MesNum=9,
SUM({1<Year={'$(V_LastYear)'},MonthNum={'>9'},Month=>}TOTAL Sales)
,IF(_MesNum=10,
SUM({1<Year={'$(V_LastYear'},MonthNum={'>10'},Month=>}TOTAL Sales)
,IF(_MesNum=11,
SUM({1<Year={'$(V_LastYear)'},MonthNum={'>11'},Month=>}TOTAL Sales)
,IF(_MesNum=12,
SUM({1<Year={'$(V_LastYear)'},MonthNum={'>12'},Month=>}TOTAL Sales)
,0)
)
)
)
)
)
)
)
)
)
)
)
The expression works for the results, but I´m trying to do it independent of the selection of "Months".
Thats why I have in the set analysis: Month=.
When I select a Month all my expression changes, but as I see it it shouldn´t.
Maybe you know what´s happening and how can I solve this problem? ( I´ve already tried with Alternate States but I would prefer another solution)
Thank you very much!
