Forum Discussion
Solved
Calculation of children in list of parents/children
Hello, I have a Bill Of Material (BOM) list, where the main item (parent) has several subitems, which in term may or may not have subitems again. It looks like this: Parent Child Qty of ch...
bartvana See if the attached file helps you find a solution for your real BOM data. Not sure, though, about the arithmetic you applied in your last table. This is what I get.
I have only used standard PQ UI commands. Nothing fancy.
bartvana See if the attached file helps you find a solution for your real BOM data. Not sure, though, about the arithmetic you applied in your last table. This is what I get.
I have only used standard PQ UI commands. Nothing fancy.
Great, thanks!
I started experimenting myself in the mean time, and ended up using a similar merge as you. I didn't think about pivoting and unpivoting however, so that was interesting to see. Seems like a perfect solution to me.
I started experimenting myself in the mean time, and ended up using a similar merge as you. I didn't think about pivoting and unpivoting however, so that was interesting to see. Seems like a perfect solution to me.