Hello Everyone,
Happy new year to everyone!
I need one help on below mention data manipulation
Input:
Output:
Hi @Ekmi9
Happy new year!!!
1. Use the filter tool
2. Then with the help of multi row formula we can derive the solution
One way of doing this
Please find the expected output.
@Ekmi9
Just the Id = 5 i couldnt understand, why the amount was distributed 7/3?
hello Thank you for you response but this not the excepted output
@Ekmi9 yes, could you explain what is the logic behind 10 being distributed as 7 for id2 = 1 and 3 for id2 = 4?
my use case is like that only
Please check if it works for you. I have tweaked the workflow to get the expected result.
@Ekmi9 without knowing the logic behind this distribution it is impossible to do it dynamically. You can fix this 7/3 value there, but it will lead to errors with new datasets.
logic is simple in id = 5 have -10 value now we have only left 7 from id 1 so we use that 7 and the add 3 more from next "s" id which 4 so that we can have total +10 and we will subtract that value from ID 5
any solution ??
