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?
Go to Solution.
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.
View solution in original post
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'
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
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:
Here attached is the reference
I have worked on it for 5 hours. Many errors. And now it is 7:05pm in HK. Please kindly help. urgent
I tried… Same error, so I couldn't create a module at all
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?
I have tried, same error. So I can't create a module at all
Do you mind give me a call, can be skype... Peggy.firstname.lastname@example.org. I can do nothing now