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

[alexnajm]

Can you show us the workflow? Even screenshots would help

My guess is that the data either refreshed between runs, or there is another TRNDBCR value being filtered out before summing - but just guessing

[JerryCooperCMA]

This appears to be classic double-entry accounting data, but as Alex says, maybe the Debits and Credits are out of balance due to data refresh timing. Relevant questions: is the difference between the "K" and "D" record transaction amounts always the same (94,600) or does it change from Run to Run? Is this a real-time data source in which data could be changing dynamically while the workflow is running? Are any filters being applied which could result in partial/incomplete accounting entries?

[novalcia]

The difference between Debit and Credit is always the same every time I run it (for that particular month). The data input is static. No filters is applied.

[alexnajm]

Then can you provide the data? Only the two columns would be needed - TRNDBCR and TRNAMNT

[jrlindem]

Without sample data, there can only be speculation.  So, I'm not saying that the article i'm posting below is related to your issue, BUT it does go into detail around how Alteryx handles numbers and it could very well give some clues as to why the numbers can aggregate in unexpected ways....

How Numbers Work in Designer: Decimals, Rounding T... - Alteryx Community

[OllieClarke]

@novalcia 

What is the data type of TRNAMNT? If it's a double/float, what happens if you change it to int64?

[novalcia]

I can't attach the data because even with only 2 columns (TRNDBCR and TRNAMNT), it's 690MB, which exceeds the allowed attachment size limit.

But here is the workflow:

[novalcia]

If I change it to int64, it still gives a difference when grouping by debit credit but the numbers are different:

[alexnajm]

Are you open to providing the data if there was a way to share the large file?