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

Comments

AnaplanIdeas

Status changed to: In Review

bdeaton

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.

RTsechoev

we also need a solution to this problem

katherinesmith

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

katherinesmith

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...

Quick Links

New ideas

Read-Only Access to Production Workspace Panel Without Admin Rights
Currently, only Workspace Admins in Anaplan can access certain model metadata and deployment validation panels (such as Revision Tags, Data Tags, etc.) in the Production workspace. For security and compliance reasons, we want to avoid granting admin-level access to users who only need to view this information. There is no…
Data Validation Enhancement
Currently, Anaplan does not natively restrict number inputs to specific ranges. Users can input any numeric value, which may result in data integrity problems, especially in collaborative or decentralised planning environments. Introducing a validation capability—where model builders set upper and lower bounds for number…
Multiple approvers in workflow when using, "select user from a line item in a module”
Currently we can assign only 1 approver when assigning using "select user from a line item in a module”. There is no option assign the task to multiple approvers and have one of them approve the task. Even if we create 2 line items each for an approver, since it is a drop down, it is currently giving an option to select…