community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Filling aggregated values in a column based on conditions

Asteroid

I have a input dataset below

 

Nameschemeratio
Afix5
Bfix5
Clight30
Dextra--
Eextra--

 

I need to create a new field "Final" which needs to calculate values based on the columns "scheme" and "ration"

 

Rules for "Final" column:

  1. sum of [Final]=100
  2. If [Scheme]="fix" OR "light", then [Final]=[ratio]
  3. If [Scheme]="extra" then [Final] should equally distribute the remaining of 100 from the rule 2

In this case, my final table should look like below

 

Nameschemeratiofinal
Afix55
Bfix55
Clight3030
Dextra--30
Eextra--30

 

Any suggestions on how to do this calculation in Alteryx? (maybe using the Formula tool)

Highlighted
Meteor

Hi @GaRaGe 

 

Something like below could work for your requirement. Hope this help. 

Thanks

 

 

Solution Final Column.png

Labels