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

Best Answers

  • @roger.griffin1 ,

     

    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

  • 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

Answers

  • Some screenshots may assist Error1.pngError2.png

     

     

  • @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.

     

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

     

    Rob 

  • @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