Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

SUMIFS

Meteor
8 - Asteroid

Hi all,

 

I am stuck with SUMIFS calculation again. Can anyone please help me building the Data(highlighted in green color) tab in the attached sample set.

 

Thanks in advance!

 

2 REPLIES 2
RolandSchubert
16 - Nebula
16 - Nebula

Hi @Meteor ,

 

in general, it works using Join and Summarize tools (Join to fulfill the "Ifs"-part , Sum does the summarizing), but the special problem is, that not all joins use all columns, so there are duplicates rows in data (e.g. joining Data to BTA works on Adjustment and Return Code only causing duplicates).

 

The solution is to remove these duplicates before joining and re-join data in the results.

 

Let me know if it works for you.

 

Best,

 

Roland

 

  

Meteor
8 - Asteroid

Thanks Roland for your help. 

 

Understood the logic behind the SUMIFS function in Alteryx Designer.

Labels