Circular References - CUMULATE

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

2 ACCEPTED SOLUTIONS

Accepted Solutions
Moderator

Re: Circular References - CUMULATE

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

Thanks,

Rob

Occasional Contributor

Re: Circular References - CUMULATE

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!

5 REPLIES 5
Occasional Contributor

Re: Circular References - CUMULATE

Some screenshots may assist

Moderator

Re: Circular References - CUMULATE

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

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

Moderator

Re: Circular References - CUMULATE

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

Thanks,

Rob

Occasional Contributor

Re: Circular References - CUMULATE

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!