Skip to content

    • CODE, PARENT AND 'GRANDPARENT' FUNCTION

    in Modeling

    Hi

    CODE(ITEM('G3 Location')) and PARENT(ITEM('G3 Location')) were defined for the following Code and Country results.  Is there a 'grandparent' function that can be used to display Region?

     

    Star_1-1584513322058.png

     

    Star_2-1584513374393.png

     

     

     

     

    Tagged:

    Best Answers

    • Answer ✓

      Hi @Star ,

       

      You can use PARENT(PARENT(ITEM('G3 Location'))). 

       

      Hope, it will help you.

       

      Thanks,

      Naushad

    • Answer ✓

      Hi @Star,

      Suggestion 2 would require the 'Applies to' to be Country List rather than Location list, right?

       

      No, You Don't Want to Change anything. it Works.

       

       

       

      Capture10.JPGCapture11.JPG

       

      You can share your error when you are following this approach.

    • Answer ✓

      @prabhu 

      Yes, it indeed worked.  Thanks 🙂

      Star_0-1584530806812.png

      Star_1-1584530902475.png

       

       

       

       

    Answers

    • Hi @Star,

       

      There is no Grand Parent Function.

       

      You can use in 2 ways.

      1. PARENT(PARENT(ITEM('G3 Location')))

      2. PARENT(Country)              Country -> Line Item

       

      Both Result the Same Output.

       

      Thanks,

      Sorna Raja Prabhu

    • @prabhu
      Suggestion 1 works perfectly.
      Suggestion 2 would require the 'Applies to' to be Country List rather than Location list, right?

    Welcome!

    It looks like you're new here. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Sign in or register to get started.
    Sign In

    Quick Links

    Categories