SOLVED
Need help breaking down units and amounts into sub-units by multiplying by a percentage
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
PD2023
5 - Atom
‎01-10-2024
10:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
- Labels:
- Help
2 REPLIES 2
nagakavyasri
12 - Quasar
‎01-10-2024
10:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
15 - Aurora
‎01-10-2024
10:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @PD2023
Here's a way to do this which scales if you have lots of amounts:
