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
Skip to content
  • Register

    • Code snippet

    edited May 8, 2020 1:39PM in Planning 2 comments

    Summary

    Essbase script for turning #MISSING driver values into 1

    Content

    Hello everybody,

    Would someone please be so kind to provide me a Essbase code to change #MISSING values in the input form for a Index (designed to be inputed by the client at the intersection "Account" --> "BegBalance") into value "1". I'm really having troubles with it. Thanks in advance

    This is how I tried, but i keep getting an error:

    FIX(@LIST(&PlanYear1, &PlanYear2, &PlanYear3), "Budget", &CurrVersion, "Dim.MemberX" )
        FIX(@RELATIVE("Account.ParentMember1",0),@RELATIVE("Account.ParentMember2",0),@RELATIVE("Account.ParentMember3",0),@RELATIVE("Account.ParentMember4",0)
          "BegBalance" (
            (IF ("Dim.MmberY"="#MISSING"))

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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