SUMIF The same parent

Luis98
New Contributor

SUMIF The same parent

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!

 

1 ACCEPTED SOLUTION

Accepted Solutions
ChrisHeathcote
Community Boss

Re: SUMIF The same parent

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

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA

View solution in original post

2 REPLIES 2
ChrisHeathcote
Community Boss

Re: SUMIF The same parent

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

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA

View solution in original post

Luis98
New Contributor

Re: SUMIF The same parent

Excellent Solution, thanks.

 

Have a good day.