function @MEMBER(@PREVSIBLING(@CURRMBR("Years")) goes into a loop
Summary:
Content (please ensure you mask any confidential information):
Hi all
While using this function: @MEMBER(@PREVSIBLING(@CURRMBR("Years"))
EXAMPLE
FIX (@RELATIVE("TotalInput", 0), @RELATIVE("Total CEBEs", 0), @RELATIVE("Total Contribution", 0), @RELATIVE("FCCS_Intercompany Top", 0), "Entity Currency", "FCCS_Entity Input", "FCCS_Local GAAP")
"FCCS_Mvmts_NetIncome" (
IF (@ISMBR("Jan"))
@CALCMODE(BOTTOMUP);
L3M Sales"="3110111"->"Dec"->@MEMBER(@PREVSIBLING(@CURRMBR("Years")))->"FCCS_YTD"->"Actual"-> "FCCS_Mvmts_NetIncome";
ENDIF
ENDIF
)
ENDFIX
0