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!
Solved! Go to Solution.
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
Thanks Roland for your help.
Understood the logic behind the SUMIFS function in Alteryx Designer.