Circular References - CUMULATE

roger.griffin1

Hi,

Anaplan is returning a circular reference eroor in the following circumstance (below are the line items - simplified);

1. Opening balance

2. Variable that depends on opening balance (1)

3. Cumulate of 2

4. Closing balance (sum of 1 & 3) - circular reference error message.

Any ideas how this can be resolved? If I manage to resolve this myself I will post an answer 🙂

Roger

Accepted answers

rob_marshall

@roger.griffin1 ,

Take a look at the below and let me know if this works for you.

Thanks,

Rob

roger.griffin1

Hi @rob_marshall ,

Thanks so much for your help. Based on your suggestion, I have amended my formulas to use PREVIOUS rather than CUMULATIVE. As noted previously, using CUMULATIVE produced a circular reference error. However, using PREVIOUS instead works perfectly (presumably because this formula specifies the precise cells). I thought I had tried this before but obviously not! Your suggestion prompted me to try again (see screenshots below). Thanks again!

Untitled picture.png ****.png

ShotA_40757.png

All comments

roger.griffin1

Some screenshots may assist

rob_marshall

@roger.griffin1

I think you might be getting confused because of the naming of your line items and are mistakeningly adding the same line item (Entries Cumulate) to itself. Take a look at the below and see if this is what you are wanting.

Hope this helps,

Rob

roger.griffin1

@rob_marshall

Hi Rob,

Thanks for your response. As background, I am trying to replicate an excel model in Anaplan. The error message I received was when I attempted to add the following formula to the Closing line item: Closing = Opening + Entries (Cumulate). Entries (Cumulate) being the cumulative of 'Entries' which in turn depends on the the Opening balance in that period. Normally the closing line item formula would simply reference the entries in the period and everything would be fine. However, the current Excel model (which i have 'inherited') references the cumulative position to work out certain line items (I have just shown an illustration in my example) in the actual model there are many line items.

Thanks

Roger

rob_marshall

@roger.griffin1 ,

Take a look at the below and let me know if this works for you.

Thanks,

Rob

roger.griffin1

Hi @rob_marshall ,

Untitled picture.png ****.png

ShotA_40757.png

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.…