Hi Alteryx Team,
I have a problem with constructing a formula for the below input -
INPUT | ROLE | AMOUNT |
Car | P | 51 |
Car | C | 25 |
Bus | P | 89 |
Bus | P | 58 |
I want the input to match firstly. If they match if Role is the same the amounts should add. If the roles are different as in 'Car' then the amount should shown/output as separate amounts.
The Output -
Input | Role | Amount |
Car | P | 51 |
Car | C | 25 |
Bus | P | 147 |
Solved! Go to Solution.