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

FCCS Custom CTA Calculation Rule running for ever

edited Dec 29, 2019 10:52AM in Financial Consolidation and Close 13 comments

Summary

FCCS Custom CTA Calculation Rule

Content

Hi,
I created a custom calculation for CTA Calculation with all tops in source POV like below. The calculation runs for hours together.
Below is my formula.

FIX (
/*DIM:Consolidation*/
"Entity Input",
/*DIM:Currency*/
"Parent Currency", "FCCS_No Movement", "Managed Data", "FCCS_No Intercompany", "[Total Cost_Center].[No Cost_Center]", "[Total Project].[No Project]", "[Total Distribution].[No Distribution]", "[Total Brand].[No Brand]")
    "CTACalc" (
        @CALCMODE(BOTTOMUP);
        /*STARTCOMPONENT:FORMULA*/
            "CTACalc"->"FCCS_Periodic" = "FCCS_YTD"->"FCCS_Total Assets"->"Managed Data"->"FCCS_Intercompany Top"->"Total Cost_Center"->"Total Project"->"Total Distribution" - "FCCS_YTD"->"FCCS_Total Liabilities and Equity"->"Managed Data"->"FCCS_Intercompany Top"->"Total Cost_Center"->"Total Project"->"Total Distribution";

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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