Issue with Summarize tool - Sum equals 0

[Maurio]

I am having an issue with the the summarize function whereby when I use the sum function to total the values in a column, I am getting a 0 value, even though the numbers do not total 0. I can't see why this is happening, however the only explanation I can think of is that the data has some negative values in it. Would this affect the sum function? I have used it before and this didn't seem to impact it.

Any help would be greatly appreciated.

[MarqueeCrew]

can you capture some incoming data and first check against it and then just post the data for a specific date that should not equal 0?  Then we can look at the process.

Cheers,

Mark

[Maurio]

Hi Mark,

Thank you for your help with this. Apologies but could you please be more specific with what information you need from me? I am quite new to Alteryx so I'm not entirely sure what you meant in your request.

Many thanks.

[var/folders/yp/llndbryn2yv800nkc8gq2bd5ttffnn/T]

Oliver Maurice
Compliance Manager,
UK Cluster Control

o: +44 (0)20 3580 3662 / m: +44 (0)7920 127236
Oliver.Maurice@vimn.com
Viacom International Media Networks
17-29 Hawley Crescent, Camden
London, NW1 8TT
[cid:image002.png@01D47DE3.A6968EC0]

[mceleavey]

Hi @Maurio ,

Mark was just asking if you could provide some of the data so we can check it. Currently, we can't see any of the figures so we have no way of knowing what the problem might be.

M.

[Maurio]

Ah I see, thank you. Please see a screenshot of the data I am trying to input below.

I am trying to sum the 'Amount1' column, grouped by the 'Month' column.

[cid:image003.png@01D51179.23695BC0]



[var/folders/yp/llndbryn2yv800nkc8gq2bd5ttffnn/T]

Oliver Maurice
Compliance Manager,
UK Cluster Control

o: +44 (0)20 3580 3662 / m: +44 (0)7920 127236
Oliver.Maurice@vimn.com
Viacom International Media Networks
17-29 Hawley Crescent, Camden
London, NW1 8TT
[cid:image002.png@01D47DE3.A6968EC0]

[mceleavey]

HI @Maurio ,

unfortunately we can't see screenshots. If you want to post a picture, save it and upload it using the "Photos" button above.

It would be easier for us if you could post an example of the data (remove anything sensitive) and we can have a look that way.

Thanks,

M.

[Maurio]

Here is the data file attached, I hope this helps!

[mceleavey · Accepted solution]

Perfect.

Okay, this was a funny one. There's nothing wrong with your data, and the answer of zero is correct. This is due to the fact that there are positive and negative numbers that net to zero.

Try filtering out the numbers that are negative and you will see the sum of the positive values.

Just to illustrate:

M.

[Maurio]

Thank you very much, that would explain it! We were sure it didn't net to zero but I've checked and we made a mistake with the source data and forgot to filter some items out!

Thank you for your help!



[var/folders/yp/llndbryn2yv800nkc8gq2bd5ttffnn/T]

Oliver Maurice
Compliance Manager,
UK Cluster Control

o: +44 (0)20 3580 3662 / m: +44 (0)7920 127236
Oliver.Maurice@vimn.com
Viacom International Media Networks
17-29 Hawley Crescent, Camden
London, NW1 8TT
[cid:image002.png@01D47DE3.A6968EC0]

[mceleavey]

No problem, glad I could help.