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

ADO connection from postgreSQL
Hi everyone, I am trying to create a connection ADO from PostgreSQL, but I consistently receive the following error: Failed to establish a connection The following message was sent from the target system: The SSL certificate is either invalid or not in unencrypted PEM format. Please check your certificate and try again.…
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
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…
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.…