Circular Reference

[peggyhai]

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?

[LipChean_Soh]

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]

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]

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:

Thanks,

LipChean

[peggyhai]

Here attached is the reference

[peggyhai]

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

[peggyhai]

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

[LipChean_Soh]

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]

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

[peggyhai]

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