Can't add a parent to a existing list

Hi all,

I am having some troubles adding a new hierarchical level to an existing list, which is called BU01 Business Unit and it's not a numbered list; the new parent should be BU00 Business Unit Combine:

If I try to compile the parent hierarchy column, I get this error:

If I try to delete All Business Unit from the Top Level column, I get this other error:

How can I solve this issue?

Thanks

Accepted answers

All comments

axel.frot

Hello LucaRicci !

In this kind of exercise, it's important to check that the formulas don't use top levels.
In this case, doesn't your formula have a "formula" summary?

Ashutosh

Hi Luca,

You need to check parent and child level and modify the formula's accordingly. Coz if u are adding new hierachy in between. Parent and child relation will change and formula will give error.

pyrypeura

Exactly as pointed that changing the parent breaks some formula logics in the model. You should start by removing the conflicting formulas. Then change the parent list and lastly fix the formulas that were causing problems.

AkhilEmmanual

Hi @LucaRicci ,

Remove the top level . For that you need to check in which all line items where this list is not a dimension and data is coming from line items where this list is used as dimension.In those line items remove the formula .
Add Parent
Put back the removed formula.

I hope this may solve your issue.

Thanks and Regards,

Akhil Emmanual

Quick Links

Can you help?

Unanswered questions

Sorting General List
Hi, I wonder if there's a way I can sort my general list alphabetically. The list is used as a drop down menu in a line item module and I want the drop down menu to be easy to navigate. I've already tried the Order List action. I already have a module with a text-formatted line item based on that list. But when I try to…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
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.…