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.
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
