Using PREVSIBLING PERIOD not working in Period with Qs
Hello Experts,
I have a dynamic calc with different IFs because there are some month that PREVSIBLING is Qs instead of level0 Base Period.
I fix this problem with different IFs like this:
IF (@ISMBR("Jan"))
"revenue"→@MEMBER(@PREVSIBLING(@CURRMBR("Year")))->"Dec";
ELSEIF (@ISMBR("Feb") OR @ISMBR("Mar") OR @ISMBR("May") OR @ISMBR("Jun") OR @ISMBR("Aug") OR @ISMBR("Sep") OR @ISMBR("Nov") OR @ISMBR("Dec"))
"revenue"->@MEMBER(@PREVSIBLING(@CURRMBR("Period")));
ELSEIF (@ISMBR("Apr"))
"revenue"->"Mar";
ELSEIF (@ISMBR("Jul"))
"revenue"->"Jun";
ELSEIF (@ISMBR("Oct"))
"revenue"->"Sep";
ENDIF
My period dimension is like this:
YearTotal
—Q1
Tagged:
0