Good day!
Freshman here and I’m hoping you could help me with below query.
I have two inputs:
And I want to allocate Input 1 and add it to Input 2 by percentage of the latter.
Therefore, my desired output should have the allocation of Input 1 plus Input 2:
I also tried GroupBy node and tried to put Group 1 and Group 2 in the “Group Columns” and did Sum as manual aggregation for values but I’m not sure what to do next to get the percentages and add the columns together.
Hopefully, this makes sense. I have also attached the workbook for clarity.
Query Allocation.xlsx (12.6 KB)
Appreciate any help!