Summarize Tool Not Giving Correct Answer

malafollette

I am trying to use a simple summarize tool too add up the amounts in one of my column and I think it is missing a row... I've attached screenshots. Any help? 🙂

Summarize Tool Result.png

Summarize Tool.png

PeterP

@malafollette ,

If the idea here is to sum the amount column rolled up to the "description1" column, then you will need to select "description1" in the summarize tool and perform a group by. I can see that you are trying to sum the amount field and renaming it to something along the lines of "amort trip goodwill". 

By selecting just the Amount field and performing a sum action, alteryx is going to add every single record in the amount field, in this case, summing up to a grand total of 0. if you are trying to sum the 4 records that equal 625953.60, which are grouped under amort trip goodwill for description1, then it will return the total you are expecting.