You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

The calculation never ends. However is we change @MEMBER(@PREVSIBLING(@CURRMBR("Years"))) to 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")

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!