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

    • IF Statement syntax error

    in Essbase 2 comments

    I am getting an syntax error on my IF statement for the script below: Error: 1200336 Error compiling formula for ["Market A"] (line 12): [(] without [)]


    FIX("Product A")

         "Market A"(IF(@ISMBR("Account A"))

    "Market B"*-1;

     ELSE (IF(@ISMBR("Account B"))

    "Market C"->"Account B"*"Market A"->"Account A";

    ELSE #missing;

    ENDIF;

    ENDIF;)

       )  

    ENDFIX


    What am i getting wrong with my brackets and semi colons?

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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