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|
Can you please help me with how to write this calculation. Hope we understood.