nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

6.9.2 Add Formulas to Product Family Details Module

model030

I am getting an error message when I enter the formula for SYS05, anyone know where I might have made a mistake?

Preview attachment IMG_20201103_212332857.jpg

IMG_20201103_212332857.jpg

833 KB

Accepted answers

All comments

GONI

Hi, Could not open the attachment.

model030

thanks for reaching out to me, hopefully it opens now,

let me know if not and I will try again

thank you

IMG_20201103_212332857_89974.jpg

GONI

Hi,

The error is because hierarchy is not defined. So check clearly did you define hierarchy in your model. As a thumb rule, it is good to check hierarchy is defined or not for respective calculation whenever ITEM keyword is used.

Also you added " at the end of formula instead of '. The correct calculation is CODE(ITEM('P1 Product Family'))

Stay Safe,

Basavaraj

GONI

Hi Zak, Did you solve the issue?

Thanks!

model030

Hi Goni,

thanks for reaching back out to me.

sadly, no I still am getting the following error message; also I must not understand what you mean by hierarchy has to be clearly defined. In my general lists I do not see where my Model differs from the real model.

I have attached an image of that as well.

thank you

Zak

IMG_20201110_123714308_90442.jpg

IMG_20201110_123640844_90442.jpg

Akhtar.shahbaz

Hi @model030 ,

Anaplan will show this error when list name is incorrect. Always recommended not to type the list name in the formula if we have number & special character.

Can you try this step to write your formula?

Edit formula bar of code line item-> write CODE(ITEM(list name)) -> Go to General lists > click on the list name.

Thanks

Akhtar

sumeyyeakin

Hello @Akhtar.shahbaz

I have a problem with clicking general lists. When I click on any of the lists as you said nothing appears in the formula, I mean it cannot be clicked. I checked everything and could not find anything wrong. It will be great if you can help me to solve this. Thanks.

Quick Links

Can you help?

Unanswered questions

How Can I Recreate Anaplan’s “Reporting Tips & Tricks” Showcase Model for Learning Purposes?
Anaplan Modelers: Has Anyone Recreated a Showcase Model for Learning Purposes? One of the most valuable learning resources I've come across is Anaplan's Modeling Showcase. It features sophisticated, real-world model examples that offer an incredible opportunity to learn how experienced model builders structure their…
Introducing Anaplan Toolkit: side panel for model details, exports and model lock tracking
Hi everyone 👋 If you build or maintain Anaplan models, you've probably hit the same walls I kept hitting. Some basic questions about a model's structure have no single screen to answer them. You end up clicking through modules and pages one by one, or writing API scripts just to get a list. These were the gaps that…
How to handle an Entity Structure change effective from January 2026 in Anaplan Consolidation & Repo
Hi Everyone, We have a requirement in Anaplan Consolidation & Reporting (Fluence) where the Entity Structure needs to change effective January 2026. The key requirement is that the existing entity structure should continue to be applicable for all reporting and consolidation periods through December 2025, while the new…