I am getting an error message when I enter the formula for SYS05, anyone know where I might have made a mistake?
Preview attachment IMG_20201103_212332857.jpg
Hi, Could not open the attachment.
thanks for reaching out to me, hopefully it opens now,
let me know if not and I will try again
thank you
Hi,
The error is because hierarchy is not defined. So check clearly did you define hierarchy in your model. As a thumb rule, it is good to check hierarchy is defined or not for respective calculation whenever ITEM keyword is used.
Also you added " at the end of formula instead of '. The correct calculation is CODE(ITEM('P1 Product Family'))
Stay Safe,
Basavaraj
Hi Zak, Did you solve the issue?
Thanks!
Hi Goni,
thanks for reaching back out to me.
sadly, no I still am getting the following error message; also I must not understand what you mean by hierarchy has to be clearly defined. In my general lists I do not see where my Model differs from the real model.
I have attached an image of that as well.
Zak
Hi @model030 ,
Anaplan will show this error when list name is incorrect. Always recommended not to type the list name in the formula if we have number & special character.
Can you try this step to write your formula?
Edit formula bar of code line item-> write CODE(ITEM(list name)) -> Go to General lists > click on the list name.
Thanks
Akhtar
Hello @Akhtar.shahbaz
I have a problem with clicking general lists. When I click on any of the lists as you said nothing appears in the formula, I mean it cannot be clicked. I checked everything and could not find anything wrong. It will be great if you can help me to solve this. Thanks.
I am attempting to connect to an azure SQL database vis at the MSSQL connector in data orchestrator but am having issues and I believe it is due to hyphens in database name (which is a fairly standard naming convention I will note!) Example below (fake credentials) - has anyone else encountered similar and is there a way…
Hi, for some reason my shipping costs are the same over every month and I don't know what to do to fix it.
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
