We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

sumif solution in alteryx

roige_28
6 - Meteoroid
‎03-06-2024 07:47 AM

Hi Guys,

 

Need help on how to convert this solution in excel to Alteryx please.

 

=SUMIF(D:D,[@EmployeeID],N:N)

 

D= employee ID

N = Quality Score

 

TIA!

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

3 REPLIES 3
apathetichell
20 - Arcturus
‎03-06-2024 07:51 AM

https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Excel%20Us...

 

particuarly the summarizing data video.

Reply
0 Likes
sergejs_kutkovics
9 - Comet
‎03-06-2024 08:16 AM

@roige_28, use Summarize tool to achieve this.

 

Capture.PNG

Reply
roige_28
6 - Meteoroid
‎03-07-2024 12:18 AM

thank you! that worked. I figured it's the summarized tool but not sure how to do it. 

Reply
0 Likes
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All