Data Manipulation

[Ekmi9]

Hello Everyone,

Happy new year to everyone!

I need one help on below mention data manipulation 

Input:

Output:

[ShankerV]

Hi @Ekmi9 

Happy new year!!!

1. Use the filter tool 

2. Then with the help of multi row formula we can derive the solution

[Felipe_Ribeir0]

Hi @Ekmi9 

One way of doing this

[ShankerV]

Hi @Ekmi9 

Please find the expected output.

[Felipe_Ribeir0]

@Ekmi9 

Just the Id = 5 i couldnt understand, why the amount was distributed 7/3?

[Ekmi9]

hello Thank you for you response but this not the excepted output 

Output:

[Felipe_Ribeir0]

@Ekmi9 yes, could you explain what is the logic behind 10 being distributed as 7 for id2 = 1 and 3 for id2 = 4?

[Ekmi9]

my use case is like that only 

[ShankerV]

Hi @Ekmi9 

Please check if it works for you. I have tweaked the workflow to get the expected result.

[Felipe_Ribeir0]

@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.