Formula Help

[henrygeorge]

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

[Dazzerman · Accepted solution]

Hi @henrygeorge 

Here is a solution for you: