tommy1234
03-09-2014, 03:09 AM
Hello
My boss asked me to do pricing calculation for huge bill of material (i attached an example).
the real BOM has 7 levels of hierarchy. in the example i used only 5 levels
I have to create sum of prices for each level / sub-assembly , level 4 has level 5 as its child, level 3 has level 4 & level 5 as its child.
after that i have to create a percentage column in which each child / sub-assembly will get its relative percentage from the top assembly (called "BBB").
the problem is that i have to overcome duplicate values and the sum of the percentage should be 100% (level 2 include 2 sub-assemblies 40% and 60%)
Please help !!!
Thank you
My boss asked me to do pricing calculation for huge bill of material (i attached an example).
the real BOM has 7 levels of hierarchy. in the example i used only 5 levels
I have to create sum of prices for each level / sub-assembly , level 4 has level 5 as its child, level 3 has level 4 & level 5 as its child.
after that i have to create a percentage column in which each child / sub-assembly will get its relative percentage from the top assembly (called "BBB").
the problem is that i have to overcome duplicate values and the sum of the percentage should be 100% (level 2 include 2 sub-assemblies 40% and 60%)
Please help !!!
Thank you