We have requirement where users wants to take value from one customer eg: (X) having 100% and distribute the value to other customers y,z,w.We have hierarchy available in story.This should be automation like using Data actions or allocation process.
Now W is given 27% from customer X ,so the ID's in W customer should get this 27% distributed according the previous values.
Means in ID the values is 6% previously, the new value should get assigned is 6% of 27%.the result should be 6%+6%0f (27)
We have tried the data action writing advanced Formulas and tried data action triggers but output is not populating correctly.
so here 27% should be deducted from customer X and it should get distributed to customer W.
Can someone please help here.