Issue with Summarize tool - Sum equals 0

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.

Capture.PNG

Workflow

Accepted answers

mceleavey

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:

All comments

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.

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]

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703