Formula

NAIDU

Hi All,

 

I have a requirement and this is a very rare formula. Please help me with the same.

 

In Numbered list has Duplicate Products for different parents.

 

For Ex: Product A is a parent member it has a 3 Childs(D, E, F)

             Product B is a parent member it has the same 3 Childs(D, E, F)

              Product C is a parent member it has the same 3 childs (D, E, F).

 

We need to move all E product data to D.

Calucualtion D = D + E

PARENT	CHILD	Data before logic		Data After logic
A
	D	100		300
	E	200		0
	F	300		300
B
	D	100		300
	E	200		0
	F	300		300
C
	D	100		300
	E	200		0
	F	300		300

     

Can you please help me with how to write this calculation. Hope we understood.

 

Regards,

Naidu