How do i recreate this SUMIFS

Question

=SUMIFS('Details'!I:I, 'Details'!A:A,C22,'Details'!$H:$H,"<>TALL",'Details'!$J:$J,"<>1900-EUB",'Details'!$J:$J,"<>1380-EUB",'Details'!$J:$J,"<>4039-FWB",'Details'!$J:$J,"<>4039-FWS") Tried using a filter tool to remove the other criterias containing the not equals to sign (<>) first before using the sum tool on just the first criteria "C22" Is there another way to do this. I want to group by "C22" but want to exclude any records that contain the values in the rest of the formula

kelly_gilbert · Answer

@HafeezA - it sounds like you're on the right track by using a Filter tool. That's exactly the step I would take to recreate a SUMIFS in Alteryx.

Can you please attach your workflow (what you've tried that didn't work) with some sample data? I'm wondering if there could be a small syntax issue in the Filter.

clmc9601 · Answer

Hi @HafeezA,

I would use a Formula tool to create a boolean column indicating whether the record should be included or not. Then filter out the irrelevant records, and then summarize.

The expression in the formula tool would be something like this:

IF

[A] = [C]

and [H] != 'TALL'

and  [J] NOT IN ("1900-EUB", "1380-EUB", "4039-FWB", "4039-FWS")

THEN 1

ELSE 0

ENDIF

If this helps, please consider marking it a solution so others may find it.

If your data is small enough, transpose could work like @apathetichell mentioned.

apathetichell · Answer

Transpose filter out wherever you don't want values. summarize. Try posting some data if you need help.