Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start 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
16 - Nebula
16 - Nebula

Hi @PD2023 

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

image.png

Labels
Top Solution Authors