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

Azure blob connection Cloudworks vs ADO
I am trying to connect to Azure blob, the credentials work on cloudworks, but do not work on ADO. Has anyone else experienced this issue?
Berapa nomor Tokopedia?
Tokopedia Menyediakan layanan WhatsApp? Untuk menghubungi layanan Tokopedia melalui (WA)62_08174_9080_16 kamu bisa mengikuti.
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…