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

[duttaabhishek]

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. 

[ShankerV · Accepted solution]

Hi @duttaabhishek 

Tried the same, it is working as expected.

Many thanks

Shanker V

[ShankerV · Accepted solution]

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]

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