Why is the overall total sum amount different from the sum amount per debit credit?

[novalcia]

I'm using the Summarize tool to just sum the amount but I got contradictory results. If I just sum the total amount directly:

but if I try to total sum by debit credit:

This is from the same data file. This happened to all my data. This still happened even after I tried to rerun it.

Why is it contradictory? I don't understand what happened.

This is the Alteryx I'm using:
Version: 2022.3.1.573 Patch: 7 

Running Non-Elevated

I also tried using Version: 2023.2.1.17242 Patch: 4 but it still happened

[JerryCooperCMA]

@novalcia what Data Type are you using? When I do a Summarize on that data using the Double data Type, I get the same discrepancy as shown in your original post, but when I use Int64 or Fixed Decimal (Size 40.2) the sum of "K" records matches the sum of "D" records. Here is the Summarized output for Double: 

Here is the Summarized output for Int64: 

Edited: you wouldn't be able to use Int64 if you have numbers to the right of the decimal, so Fixed Decimal is probably best. You just need to know how big your individual values can get, accounting for decimals and negative sign when sizing. I'm not sure if a ticket is needed or if this is just one of those scenarios (very large numbers and lots of them) where floating-point precision suffers when you add them all together.

[AkimasaKajitani]

Please read this article.

https://community.alteryx.com/t5/Engine-Works/Handling-Unusually-Large-Numbers-in-Alteryx-Designer/b....