Lookup between two lists formated line items

Hi guys, im trying to do this lookup. 
I will start by stating the goal i want to achieve:
i have 2 lists formated line items in module 1: Product and Partner. In module 2 i have one list formated line item called "quantity".
in module 1 i have a line item named "auto" that should be auto filled according to user's selection on the list formated line item called "partner".
when the user select product 1 and partner 1 i want the line auto
to autofill according to values stored in "quantity" (module 2)
module 2 is dimensionned by the lists "Product" and "partner". 

ive included a pic of what i want to achieve. 

Thanks in advance for your support 🙂

pdekas_0-1634025299012.png

 

Best Answer

  • PujithaB
    Answer ✓

    @pdekas 

    In that case you can use LOOKUP inplace of SUM as below

    PujithaB_0-1634029429091.png
    PujithaB_1-1634029462784.png

     

     

    Hope this will help out


    Pujitha

     

Answers

  • @pdekas 

    From the image , My understanding is that first module will be dimension by product  and line items
    when user selects partner , quantity has to be populated from second module 

    This can be achieved using SUM function 
    Module 1 Quantity Lineitem = Module 2. Quantity Lineitem[sum: Module 1. Partner Lineitem]

    Hope this will helps out

    Pujitha

  • Hi, thanks for your reply.
    im not trying to sum the quantities, they could even have been alphanumeric characters.
  • mismatched dimension level. i will try to further look into the dimension levels...