Want to get the Sum for each account number. The Summarize tool is not working.
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Labels:
- Developer
- Developer Tools
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It seems to be working for me too. Not sure what I did wrong the first time. Thanks again and sorry for the inconvinience.