Adding fields with specific criteria in a column

[jessy_chow]

I hope my question makes sense. 

I am trying to replicate what was previously done in excel into alteryx. I am currently stuck on adding up together specific criteria's in alteryx. 

In the column CE, there are specific CE's that I want to add up together to get a total to do an allocation. I specifically want 603020, 603010, 603030, 603040, 603070, 603080, 603085 and 603090 to be added up together to get a total, so then I can do allocation afterwards. 

I have attached my data for alteryx and the excel file that I am trying to mimic. 

Thanks for your help! 

[abacon · Accepted solution]

@jessy_chow If you are just wanting to add the values where the [CE] is in the range you gave, you could use the below function, then filter to the 'Yes'. Sum up the values and move to your next step.

if tostring([CE]) in ('603020', '603010', '603030', '603040', '603070', '603080', '603085', '603090') then 'Yes' else 'No' endif

Bacon

[jessy_chow]

thanks! 

[caltang]

If it helps, kindly mark @abacon ‘s response as an accepted solution to help close the thread.