Highlighted
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?

 

 

13 REPLIES 13
Highlighted
Master Anaplanner/Community Boss

Re: Circular Reference

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

Highlighted
New Contributor

Re: Circular Reference

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

Highlighted
Master Anaplanner/Community Boss

Re: Circular Reference

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

Highlighted
New Contributor

Re: Circular Reference

Here attached is the referencecircular references.PNG

Highlighted
New Contributor

Re: Circular Reference

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

Highlighted
New Contributor

Re: Circular Reference

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

Highlighted
Master Anaplanner/Community Boss

Re: Circular Reference

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

Highlighted
New Contributor

Re: Circular Reference

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

Highlighted
New Contributor

Re: Circular Reference

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