Count number of parent for Unstructured List

PratyakshDua01
Contributor

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.

4 REPLIES 4
JaredDolich
Moderator

Re: Count number of parent for Unstructured List

@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?


Jared Dolich
rob_marshall
Moderator

Re: Count number of parent for Unstructured List

@PratyakshDua01 

 

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

PratyakshDua01
Contributor

Re: Count number of parent for Unstructured List

Hi @rob_marshall 

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

PratyakshDua01
Contributor

Re: Count number of parent for Unstructured List

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.