Parent - selected item from the parent list

Dominika_Dudzinska
Dominika_Dudzinska
in Modeling

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?

Tagged:

Answers

  • Misbah
    Misbah

    @Dominika_Dudzinska 

     

    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

  • Dominika_Dudzinska
    Dominika_Dudzinska

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

  • Misbah
    Misbah

    @Dominika_Dudzinska 

     

    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

Categories