not recognised as a hierarchy

Sam007

Hi getting below message when I try to add formula to code as per 6.8.2 Activity .

Accepted answers

ArunManickam

@Sam007

Do not type the list name when editing the formula, goto General lists > click on the list name

This should resolve it.

Thanks

Arun

All comments

anirudh

Hi Sam,

Could you share a screenshot of all the lists in your model

Regards,
Anirudh

ArunManickam

@Sam007

Do not type the list name when editing the formula, goto General lists > click on the list name

This should resolve it.

Thanks

Arun

Sam007

Hope you can see this, thank you in advance

Sam007

Thanks Arun,

Will try this.

ArunManickam

Avoid those special characters on list names, module names and line item names.

Thanks

Arun

OBamgbola

The Solution of just clicking from General Lists did not work for me! (I think because I am using the newer interface)

However, it pointed me in the right direction.

I started by copying/typing and pasting the whole formula including G3 Locations in the edit section that opens when you click on the double chevrons.> Then I went to general lists > double clicked on G3 Locations (it turns blue and editable)> I then highlighted and copied the blue text version of G3 Locations> Then highlighted G3 Locations part that I had originally typed/pasted and pasted what I copied from the general lists to replace it.

It looks identical, spacing and everything was the same but it worked

This SOLVED it for me. Hope this helps the next person not waste as much time as me!

Anaplan_screen_shot_132387.png

Quick Links

Can you help?

Unanswered questions

Missing Column Headers in Anaplan Export When Using API
Hi Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…
Postman/Anaplan - message "404, Not found"
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…
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.…