Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

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

novalcia
7 - Meteor

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

total sum.png

but if I try to total sum by debit credit:

sum per debit credit.png

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

1 REPLY 1
alexnajm
18 - Pollux
18 - Pollux

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

Labels
Top Solution Authors