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?
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
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'
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
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 tried… Same error, so I couldn't create a module at all
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.hai@pernod-ricard.com. I can do nothing now
I'll pm you.
thanks a lot.
You will PM me via Skype? What time? As it is 7:38pm in HK now. I am very hungry
Great job @LipChean_Soh LipChean! Thanks for sharing it.
I hope @peggyhai managed to have dinner in time! haha.
I was getting this circular reference error in my Excel application. So I can tell you how I have fixed this error in Excel.
Well, this particular circular reference error occurs when the formula either directly or indirectly refers to the cell in which it is already contained. Due to this, the formula starts calculating the already obtained result which leads to generating this type of error.
Give it a try at all the fixes listed in this post. I found this article very helpful as the listed solution worked in my case.
source: fix circular reference error
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
