Hello Guys, I have this Project in which I am supposed to convert this Indented BOM (Bill of materials) and convert it to a desired output (please see the attached file) at first glance I believed it was an easy problem, however when dealing with indented bills the item will be at a certain level and the quantity of the item will depend on that. Take an example (on the attached sheet)
Bolt1 is three times on the list,
- The first one on level 2 (inside of subassy 1, subassy 1 has a quantity of 2) and it has a quantity of 3; therefore we will have 3X2=6... 6 being the number of bolts1 on that level.
-The second one is on level level 3 (inside subassi3, which is inside of subassy2), and it has a quantity of 4, since bolt one is inside of "subassy3",4 quantities, and "subassy3" is inside "subassy2", 2 quantities. therefore we will have 4X4=16 (now at level three we go up the level and; 16X2=32... 32 being the number of bolts on that level.
- the third Bolt1 is located on level 1 and there is 1 quantity, since is on level on 1x1=1 having only 1 bolt.
Finally adding up all "bolt1" we would have 6+32+1=39 Bolt1.
I will need to do that for all the parts listed on the indented bill, i have tried using the vlookup function and it will return to me the number, however i dont know how to implement the indented level of the bill.
If someone could help me I will greaatly appreciate it.
Thanks!
Bookmarks