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

The content in this article has not been evaluated for all Anaplan implementations and may not be recommended for your specific situation.
Please consult your internal administrators prior to applying any of the ideas or steps in this article.
4 Comments
Previous Contributor
 
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

New Contributor

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