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.
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
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.…
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…