topic Parent - selected item from the parent list in Anaplan Platform https://community.anaplan.com/t5/Anaplan-Platform/Parent-selected-item-from-the-parent-list/m-p/124696#M31441

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 - MATERIALList B - PARENT
Material A1_2021
Material A2_2021
Material A4_2021

 

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

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

Is it possible?

 Fri, 12 Nov 2021 09:28:28 GMT Dominika_Dudzinska 2021-11-12T09:28:28Z Parent - selected item from the parent list https://community.anaplan.com/t5/Anaplan-Platform/Parent-selected-item-from-the-parent-list/m-p/124696#M31441

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 - MATERIALList B - PARENT
Material A1_2021
Material A2_2021
Material A4_2021

 

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

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

Is it possible?

 Fri, 12 Nov 2021 09:28:28 GMT https://community.anaplan.com/t5/Anaplan-Platform/Parent-selected-item-from-the-parent-list/m-p/124696#M31441 Dominika_Dudzinska 2021-11-12T09:28:28Z Re: Parent - selected item from the parent list https://community.anaplan.com/t5/Anaplan-Platform/Parent-selected-item-from-the-parent-list/m-p/124701#M31442

 

 

See if this helps

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

 

Misbah_0-1636713328877.png

Misbah_1-1636713355983.png

Misbah

Miz Logix

 Fri, 12 Nov 2021 10:37:53 GMT https://community.anaplan.com/t5/Anaplan-Platform/Parent-selected-item-from-the-parent-list/m-p/124701#M31442 Misbah 2021-11-12T10:37:53Z Re: Parent - selected item from the parent list https://community.anaplan.com/t5/Anaplan-Platform/Parent-selected-item-from-the-parent-list/m-p/124841#M31481

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

 Mon, 15 Nov 2021 08:08:56 GMT https://community.anaplan.com/t5/Anaplan-Platform/Parent-selected-item-from-the-parent-list/m-p/124841#M31481 Dominika_Dudzinska 2021-11-15T08:08:56Z Re: Parent - selected item from the parent list https://community.anaplan.com/t5/Anaplan-Platform/Parent-selected-item-from-the-parent-list/m-p/124843#M31482

 

 

In that case create few more line items

Second Delimiter = FIND("_", Parent, Delimiter)

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

Rest all will remain same

 

Misbah

Miz Logix

 Mon, 15 Nov 2021 09:32:55 GMT https://community.anaplan.com/t5/Anaplan-Platform/Parent-selected-item-from-the-parent-list/m-p/124843#M31482 Misbah 2021-11-15T09:32:55Z