Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
can it be further Optimize — Cloud Customer Connect
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

can it be further Optimize

Question
9
Views
0
Comments
edited Aug 2, 2018 2:36AM in Essbase

Summary

can it be further Optimize

Content

FIX(2018,budget,@RELATIVE(Boston,0),@REMOVE(@LIST(@RELATIVE(Sales,0),@UDA("ACCOUNT",Sales)),@UDA("ACCOUNT","CALC")))

    FIX(@RELATIVE("Ad",0))

        FIX("M1":"M12")

            CLEARDATA "YearToDay";

        ENDFIX

    ENDFIX

ENDFIX

FIX(2018,budget,@RELATIVE(Boston,0),@REMOVE(@LIST(@RELATIVE(Sales,0),@UDA("ACCOUNT",Sales)),@UDA("ACCOUNT","CALC")))

    FIX(@RELATIVE("Ad",0))     

        FIX("M1":"M12")

            "YearToDay"(

                @CALCMODE(CELL);

                IF(@ISMBR("M1") OR @ISACCTYPE ("Last"))

                    "YearToDay" = "MonthToDay";

                ELSE

                    "YearToDay" = "MonthToDay" + @PRIOR("YearToDay");

                ENDIF

            )

        ENDFIX

    ENDFIX  

ENDFIX

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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