Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Want to get the Sum for each account number. The Summarize tool is not working.

duttaabhishek
7 - Meteor

Hi All. I have the attached dataset. I want to get the total amount for each Account number. I tried using the summarize tool to get the total amount for each account number. Its not giving me the sum of all the amount in USD. Instead its giving me the first entry. What am I doing wrong. 

3 REPLIES 3
ShankerV
17 - Castor

Hi @duttaabhishek 

 

Tried the same, it is working as expected.

 

Screenshot 2024-04-25 113743.png

Many thanks

Shanker V

ShankerV
17 - Castor

Hi @duttaabhishek 

 

In the input file, we have 12,777 records

Post summarize tool, we get 11701 records

 

This indicates that, we have more unique account numbers. 

It looks like we have only the first record coming in output for Summarize tool. Actually Summarize tool works as expected.

 

Many thanks

Shanker V

 

 

duttaabhishek
7 - Meteor

It seems to be working for me too. Not sure what I did wrong the first time. Thanks again and sorry for the inconvinience.

Labels
Top Solution Authors