I have a input dataset below
Name | scheme | ratio |
A | fix | 5 |
B | fix | 5 |
C | light | 30 |
D | extra | -- |
E | extra | -- |
I need to create a new field "Final" which needs to calculate values based on the columns "scheme" and "ration"
Rules for "Final" column:
In this case, my final table should look like below
Name | scheme | ratio | final |
A | fix | 5 | 5 |
B | fix | 5 | 5 |
C | light | 30 | 30 |
D | extra | -- | 30 |
E | extra | -- | 30 |
Any suggestions on how to do this calculation in Alteryx? (maybe using the Formula tool)
Solved! Go to Solution.