Circular Refference - using prior month value

Hi everyone,
I'm having troubles creating a module that recalculates a regression each month. My regression is based on values of the last 12 months. When there are no 12 months of histicorical data available, I want the line item to use the previously predicted values with the regression as input for future values. This creates a situation in which I get the "circular refererence error".

Does anyone have encounterd this problem or has some advise to fix this problem?

many thanks

Accepted answers

nathan_rudman

Hello,

you need to use the previous() formula to reference the line item where your calculation is: previous(my regression). Don't hesitate to do it in several line items for clarity.

All comments

nathan_rudman

Hello,

you need to use the previous() formula to reference the line item where your calculation is: previous(my regression). Don't hesitate to do it in several line items for clarity.

RalfdeGier

Dear Nathan,

Thanks for your reply. I made 12 line items which simulated the previous last months. This did the trick!

Many thanks.

Quick Links

Can you help?

Unanswered questions

Set text encoding format for anaplan connect script upload
Hi, I would like to specify in an Anaplan Connect script that UTF-8 text encoding should be used for the file I am uploading. Does anyone know the command for this, or another way to make this happen? Thanks!
AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…