Hierarchy and Depths

[Dayna]

Dear all,

I have been trying to achieve a Bill of Materials using various functions, and finally I was able to achieve (I think!) what I needed using the HierarchyBelongsTo function…

However, my costs are wrong as the higher level components include the costs for the lower level, so what I need to do is ignore the cost for any component that has a sub component. But how do I go about calculating which item belongs to which?

Here is an example output of data:

Comp	LL Cost Comp	TL Cost Comp	Depth
SA9500FW1	0.206807692	0	0
SA9500FW2	0.219461539	0	0
6852A	0	0.228	1
20935H	0	0.0198	1
20940H	0	0.0198	1
4488	0.23199834	0	1
4489	0.23043029	0	1
5011	0	0	1
5011	0	5	1
5011	0	7.5	1
6857	0	0.159	1
10859	0	0	1
10859	0	0.003744164	1
10859	0	0.00425	1
10859	0	0.0139	1
31055	0	0.1354	1
7008	0	0	2
7008	0	83	2
7008	0	104.89	2
7035	0	0	2
7035	0	29.5	2
7035	0	62.1	2
7143	0	0	2
7143	0	2.92	2
7143	0	3.1	2
7143	0	3.17	2
7157	0	0	2
7157	0	1.89	2
7157	0	2.24	2
7173	0	0	2
7173	0	6.89	2
7173	0	9.7	2
7241	0	0	2
7241	0	12.8	2
7241	0	13.73	2
7244	0	0	2
7244	0	1.8	2
7244	0	2.3	2
7246	0	0	2
7246	0	2.9	2
7246	0	3.49	2
7259	0	0	2
7259	0	3.15	2
7259	0	4.6	2
7304	0	0	2
7304	0	0.195	2
7304	0	0.31	2
7428	0	0	2
7428	0	16.35060001	2
7428	0	16.43919	2
7440	0	0	2
7440	0	3.507457604	2
7440	0	4.5	2

Many thanks for any help you could provide!!

Kind Regards,
Dayna

[#2 · Accepted solution]

IS this what you mean?

[Dayna]

I will have a look and let you know! Thanks Jochem!

[#4]

IS YOUR PROBLEM SOLVED??

[Dayna]

Jochem,

I have been on annual leave, so I don't know if it resolves my issue 100%. But it seems to break down the components.

Many thanks,
Dayna

[#6]

Hi Jochem

I see your qvw about this topic, also I have a question for you.

It's possible with the semi-elaborate products has the BOM explossion with hierarchy

Let me explain

You have a Final Product  with this formula, but in the formula you have a code who has his own formula

I have maybe 3 or 4 levels in some products.  Any Ideas?

The final output its only have materials requirements with the semi-elaborate requirements.

thank you