Cast your vote for the official 2025 Inspire Pin! Designs were submitted by fellow Community members and reflect the creativity and passion of Alteryx users across the globe. Vote now!
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Need help breaking down units and amounts into sub-units by multiplying by a percentage

PD2023
5 - Atom

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.

 

 

Screenshot 2024-01-10 114753.png

2 REPLIES 2
nagakavyasri
12 - Quasar

@PD2023 

 

check this:

 

Capture10.PNG

OllieClarke
15 - Aurora
15 - Aurora

Hi @PD2023 

Here's a way to do this which scales if you have lots of amounts:

image.png

Labels
Top Solution Authors