Count number of parent for Unstructured List

Hi Team,

I am trying hard to calculate the number of parents for individual list items for unstructured list items.

Kindly let me know in case of an optimized formula

IF NAME(PARENT(ITEM(Region_Group))) = "All Regions" THEN 1 ELSE IF NAME(PARENT(PARENT(ITEM(Region_Group)))) = "All Regions" THEN 2 ELSE IF NAME(PARENT(PARENT(PARENT(ITEM(Region_Group))))) = "All Regions" THEN 3 ELSE 4

this is not going to work if I add any other list item for more levels.

Thanking you in anticipation.

Accepted answers

All comments

JaredDolich

@PratyakshDua01

Seems like a simple system module will do the trick. If the Parent is not the top level = 0, if it does, then 1. Then all you have to do is sum up the 1's. Would that work?

Generally, it's not a good practice to use nested IF statements especially with hard coded values. Make sure the top level is a line item, not a hard coded value.

Need an example?

rob_marshall

@PratyakshDua01

And please don't nest the PARENT function, please break it up. Also, please look into the Ancestor function.

PratyakshDua01

Hi @JaredDolich,
Thanks for your response, I would be very happy if you can share one example of this because I tried but bcos of the unstructured list it's creating issues.

PratyakshDua01

Hi @rob_marshall

Thanks for your response, yes I will make sure to avoid the nested parent functions.

Quick Links

Can you help?

Unanswered questions

Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
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.…