Circular Reference Error While Calculating Opening Base with Custom version

aishabhy05
aishabhy05
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