I have data with units that are made up of subunits where the amounts need to be allocated from the Unit to the subunits by an ownership percentage.. I need help creating a flow to break these units down into subunits by multiplying all their amounts by an applicable percentage. I have attached a screenshot of a spreadsheet showing a simplified version with the my start data, percentages, and my desired output.
Solved! Go to Solution.
Hi @PD2023
Here's a way to do this which scales if you have lots of amounts: