Circular Reference Error While Calculating Opening Base with Custom version

BlueSky-Wind chaser
BlueSky-Wind chaser
in Modeling

Hi All.

 

I'm facing an issue in solving the Opening Base Calculation. Please help to resolve it!!!

 

Custom Versions - Actual, Estimate,Budget

Time Period (in Months)

Country List

Department List

GL Accounts

 

In the below screenshot, closing base is the sum of Opening Base,Gross Activation and Churn Rate. 

aishabhy05_0-1647220266218.png

When i try to calculate the opening base ( first month of the calendar year will be input following months will be previous month data to be copied (which includes custom versions)) it s throwing me circular reference error. However i try to create staging module, I'm not able to achieve the desired result as per the below screenshot. 

aishabhy05_1-1647220510036.png

 

Thanks in Advance !!

 

Aish

Tagged:

Best Answer

  • Panji
    Panji
    Answer ✓

    HI @aishabhy05,

     

    For you error, you need to split module to every version and then need to combine

     

    1. you can create 3 module (without dimension version) Actual, Estimate, and Budget

    2. for Actual module have 2 Opening base (input and formula)

    Panji_0-1647238279217.png

    3.for Estimate module only have 1 opening base(formula) and get amount form closing actual

    Panji_1-1647238408536.png

    4. for budget module only have 1 opening base(formula) and first period get amount form closing estimate

    Panji_2-1647238598783.png

    5. Last for Final module, you can combine all version

    Panji_3-1647238955683.png

    Here the blueprint file

     

    Regrads,

    Panji

     

Answers

Categories