topic Re: Adding fields with specific criteria in a column in Alteryx Designer Desktop Discussions

Adding fields with specific criteria in a column

jessy_chow — Tue, 24 Jun 2025 15:47:06 GMT

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!

Re: Adding fields with specific criteria in a column

abacon — Tue, 24 Jun 2025 16:12:09 GMT

@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

Re: Adding fields with specific criteria in a column

jessy_chow — Tue, 24 Jun 2025 19:02:44 GMT

thanks!

Re: Adding fields with specific criteria in a column

caltang — Wed, 25 Jun 2025 02:18:10 GMT

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