SUMIFS

[Meoth]

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!

[RolandSchubert · Accepted solution]

Hi @Meoth ,

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

[Meoth]

Thanks Roland for your help. 

Understood the logic behind the SUMIFS function in Alteryx Designer.