SUMIF The same parent

Luis98
Luis98
in Modeling

Hello, I have a situation, I have a list named "BOM Lvl 1", with the parent "plant sku", and these parent have a "total price".

Luis98_0-1622561844965.png

Then, I have another list "SKU Plant Price" where the "Plant SKU" is the same in two lists , and i need to accumulate the total price in these new list:

Luis98_1-1622561968391.png

Thanks, have a good day!

 

Tagged:

Best Answer

  • ChrisAHeathcote
    ChrisAHeathcote
    Answer ✓

    @Luis98 

    Firstly transfer the detail held in the properties of list BOM Lv 1 List. Dimension a module by the list and create line items to accommodate the data. Link directly to the properties in the list to pull the data into the module.

     

    Secondly, use LOOKUP in the BOM Lvl1 item property using the Plant SKU property as the mapping. 

     

    This will pull through the value of the parent held in the module created in the first step. 

Answers

Categories