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

Code snippet

Received Response
42
Views
2
Comments
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"))

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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