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

SUMRANGE not working in Essbase 516 but work with 21C

in Financial Consolidation and Close 1 comment

Summary:

Content (please ensure you mask any confidential information):

Hi All

I have an issue where this script using SUMRAGE does not sum data from JAN to DEC but only until NOV with the current essbase version 516. However with the new 21C essbase it works perfectly.

Any changes we need to be aware of: —————————————————————————

FIX(@RELATIVE ("FCCS_TotalInputAndAdjusted", 0),@LEVMBRS ("CEBES", 0), @LEVMBRS ("FCCS_IFRS", 0),@LEVMBRS ("Total Contribution", 0), @LEVMBRS ("Intercompany",0),"Parent Currency","FCCS_Entity Input")

    FIX(@REMOVE (@RELATIVE ("FCCS_Total Balance Sheet-Traditional Approach",0), @LIST ("FCCS_CTA","FCCS_CICTA","FCCS_Balance", "FCCS_REC OBFXCTA",@RELATIVE ("FCCS_Net Income", 0))))

       "FCCS_OpeningBalance"(

           IF ((@ISMBR ("[SC_Serbia].[E0370]") AND@ISMBR ("Dec") AND @ISMBR ("FY25")))

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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