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