Parent - selected item from the parent list

[Dominika_Dudzinska]

Hello,

Is it possible to set up/select of the displayed parent in Anaplan?

I have a list of materials (A) whose parent is list (B).

List A - MATERIAL	List B - PARENT
Material A	1_2021
Material A	2_2021
Material A	4_2021

When I apply the formulas for Parent: PARENT(MATERIAL) then forMaterial AI get the result:1_2021

I would like to get the last item in list B -4_2021

Is it possible?

[Misbah]

@Dominika_Dudzinska

See if this helps

I have created one Flat List for Materials - Which is a Non Numbered list

Misbah

Miz Logix

[Dominika_Dudzinska]

@MisbahThank you for the solution.
The only problem is that sometimes the parent has plant in its name and then its name is XXX_1_2021 or XX_1_2021, so I have to use something more flexible here.

[Misbah]

@Dominika_Dudzinska

In that case create few more line items

第二个分隔符=找到(父,“_”分隔符)

and then use MID function to extract 1,2,3 .....31.

Rest all will remain same

Misbah

Miz Logix