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.