topic To use Lookup in a Flatlist in Anaplan Platform https://community.anaplan.com/t5/Anaplan-Platform/To-use-Lookup-in-a-Flatlist/m-p/106478#M25392

Hi All,

 

I have a scenario, as follows:

 

Module 1 : 

To get Headcount in this module

 

Dimensions: L6 hierarchy, L6 Flat List(same hierarchy as a flat list), Cost Centre

Line Item: HeadCount

Time by month

 

Module 2:

Dimensions: L6 Hierarchy, Grade, Contract Type

Line ITem: HeadCount

Time by month 

 

I wanted to get the headcount in module 1 by referring to module 2.the headcount in module 1 should be by the L6 flat list. ( Not by L6 hierarchy). Any inputs, please?

 

Thanks 

 

 Tue, 27 Apr 2021 13:55:53 GMT aishabhy05 2021-04-27T13:55:53Z To use Lookup in a Flatlist https://community.anaplan.com/t5/Anaplan-Platform/To-use-Lookup-in-a-Flatlist/m-p/106478#M25392

Hi All,

 

I have a scenario, as follows:

 

Module 1 : 

To get Headcount in this module

 

Dimensions: L6 hierarchy, L6 Flat List(same hierarchy as a flat list), Cost Centre

Line Item: HeadCount

Time by month

 

Module 2:

Dimensions: L6 Hierarchy, Grade, Contract Type

Line ITem: HeadCount

Time by month 

 

I wanted to get the headcount in module 1 by referring to module 2.the headcount in module 1 should be by the L6 flat list. ( Not by L6 hierarchy). Any inputs, please?

 

Thanks 

 

 Tue, 27 Apr 2021 13:55:53 GMT https://community.anaplan.com/t5/Anaplan-Platform/To-use-Lookup-in-a-Flatlist/m-p/106478#M25392 aishabhy05 2021-04-27T13:55:53Z Flatlist Re:使用查找 https://community.anaplan.com/t5/Anaplan-Platform/To-use-Lookup-in-a-Flatlist/m-p/106479#M25393 Use Find Item so that you have the appropriate flat list member.

Then you can use Lookup to find the headcount associated with it

Line Items:
L6: ITEM(L6 Hierarchy)
L6 Name: NAME('L6')
Matching FL L6 List Member: FINDITEM(L6 Flat List,'L6 Name')
Flat List HC: Flat List Module.Headcount[LOOKUP: 'Matching FL L6 List Member'] Tue, 27 Apr 2021 14:02:40 GMT https://community.anaplan.com/t5/Anaplan-Platform/To-use-Lookup-in-a-Flatlist/m-p/106479#M25393 obriegr 2021-04-27T14:02:40Z