LOOKUP does not work on list parents and only leaf items

LOOKUP does not work on list parents and only leaf items

When a LOOKUP is done on a parent item in a module, the result does not resolve to the column with that respective parent. Subsequently the value shows 0.
To reproduce:
1. Create list with leaf item and parent
2. Create module with column 1 as "Data", column 2 as "Parent", and column 3 as "Lookup", using list from 1. as the dimension.
3. In column 2, set formula to "PARENT(ITEM(List))"
4. In column 3, set formula to Data[LOOKUP:Parent]
Column 3 displays 0

Community Manager
Status changed to: Considered for Future Roadmap
Certified Master Anaplanner

We have just encountered this a few times and have a workaround we think will work. But it's limited in use, especially when we are using large lists. We would be very interested in seeing this issue resolved.

New Contributor

we also need a solution to this problem

Occasional Contributor

We are also experiencing this issue. Please add parents if I'm looking up anything in that chain!

Occasional Contributor

Wanted to bring attention to this again to see if anyone has a better solution. I'm just hoping to be able to do lookups on the parent of a flat list, not even a full on hierarchy...


Common example I'm experiencing:

I have a list of Market Segments. The Top Level is "All Segments." I create a boolean dependent on the Market Segment. There are high level sales mgrs who have "All Segments." The boolean lookup doesn't work for them because the lookup won't recognize "All Segments."


My work-around right now is a static IF statement at the start of each lookup for IF Segment = All Segments Then TRUE ELSE Boolean[Lookup: Segment].

It's not great...