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
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
