error code received and i dont know why
i entered CODE(ITEM('P1 Product Family'))
received this message:
'P1 Product Family is not recognized as a hierarchy in the model
The ITEM function should take a hierarchy as argument
Hi @Bordenk612 ,
Anaplan will show this error when you type incorrect list name.
Can you try this step to write the list name in your formula?
Go to General lists > click on the list name
Thanks
Akhtar
Thank you,
I realized that I had misspelled Family(famiy) in my general list...
Is there a way to edit the name in the general list without deleting it?
@Bordenk612
Yes, Go to general list, double click on the list & rename your list name
If in doubt, we always recommend clicking on the lists/line items etc. rather than typing; with numbers or special chrs, it can get quite tricky to get the exact syntax. For Lists, navigate to the General list setting and then you can click on the relevant list
David
Hello,
My lists cannot be clicked for some reason. I want to click on them while writing the formulas but it does not work for me. It will be great if you can help me to solve this.
Thanks.
I am trying to create a Net Debt / EBITDA formula at the bottom of one of our P&L income statements where, i have tried the MOVINGSUM function. However this does not work for summary line items which EBITDA is. What i would like is to be able to sum the previous 12 months EBITDA (Including the current period) numbers in a…
Hi I'm looking to speak to people who have used/are using the Docusign integration in their business. We are exploring the possibility, but we find the current setup quite limiting in terms of how an end user would interact with the integration, but also issues with concurrency and number field formats. Would appreciate…
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…
