Circular Reference

peggyhai
New Contributor

Circular Reference

I am creating a model.

 

But when I input something on the line items, then there are errors "circular reference" popping up".  Would you help?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
LipChean_Soh
Certified Master Anaplanner

Hi,

 

For the folks out there, the circular reference happened during a module creation, because of an error in Standard Version formula, i.e. Forecast = Actual - Forecast.

 

The circular reference error didn't happen during the Standard Version formula processing, but during the creation of a module involving standard Version.

 

Thanks,

LipChean

View solution in original post

14 REPLIES 14
LipChean_Soh
Certified Master Anaplanner

Hi Peggy,

 

Please provide more context, descriptions and screen shots of your model for us to help.

 

But essentially, you get a circular reference problem when you create a line item that refers to itself, eg

Line Item A = 2 * 'Line item A'

 

Thanks,

LipChean

peggyhai
New Contributor

I can't add excel or pdf file or add screen shots here.  As I don't have JPEG

 

Can you give me an email address to me so that I can send you screen shot

LipChean_Soh
Certified Master Anaplanner

Hi Peggy,

 

You can do a 'Print Screen', i.e. look for 'prt sc' on your keyboard.

Then you can insert photo by clicking on the icon as shown below:

Screen Shot 2019-05-08 at 12.55.54 PM.png

 

Thanks,

LipChean

peggyhai
New Contributor

Here attached is the referencecircular references.PNG

peggyhai
New Contributor

I have worked on it for 5 hours.   Many errors.   And now it is 7:05pm in HK.   Please kindly help.   urgent

peggyhai
New Contributor

I tried… Same error, so I couldn't create a module at all

LipChean_Soh
Certified Master Anaplanner

Hi,

 

Did you get the error message when you clicked 'Ok' and tried to create the module?

 

Normally we get circular reference error when we tried to process a formula.

 

Can you try inserting only 1 line item, eg Units and see if the module can be created?

 

Thanks,

LipChean

peggyhai
New Contributor

I have tried, same error.  So I can't create a module at all

peggyhai
New Contributor

Do you mind give me a call, can be skype... Peggy.hai@pernod-ricard.com.   I can do nothing now