Circular References - CUMULATE

Highlighted
Occasional Contributor

Circular References - CUMULATE

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

5 REPLIES 5
Highlighted
Occasional Contributor

Re: Circular References - CUMULATE

Some screenshots may assist Error1.pngError2.png

 

 

Highlighted
Master Anaplanner/Community Boss

Re: Circular References - CUMULATE

@roger_griffin 

 

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.

 

2019-01-30_07-18-44.png2019-01-30_07-18-54.png2019-01-30_07-19-08.pngHope this helps,

 

Rob 

Highlighted
Occasional Contributor

Re: Circular References - CUMULATE

@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

Highlighted
Master Anaplanner/Community Boss

Re: Circular References - CUMULATE

@roger_griffin ,

 

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

 

2019-01-30_14-41-36.png2019-01-30_14-41-48.png

 

Thanks,

 

Rob

Highlighted
Occasional Contributor

Re: Circular References - CUMULATE

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.pngShotA.png