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