Adding fields with specific criteria in a column

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!

Vehicle Allocation 2024.xlsx

Vehicles Test.yxmd

Designer Cloud

Accepted answers

abacon

@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

All comments

abacon

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

Bacon

jessy_chow

thanks!

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280