Circular Reference Error While Calculating Opening Base with Custom version

aishabhy05

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.

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.

Thanks in Advance !!

Aish

Accepted answers

Panji

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)

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

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

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

Here the blueprint file

Regrads,

Panji

Grid_134001.xlsx

All comments

Panji

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)

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

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

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

Here the blueprint file

Regrads,

Panji

Grid_134001.xlsx

aishabhy05

Thanks!!! This Works

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…
Exports with anaplan using informatica connector
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…