It's not 13 it's 10. There are 10 transaction (see the first sheet). So the average per transaction is 13.9.
It would be great if you spent a few minutes to understand what someone is saying when they post.
There is 13 records, there are 10 distinct Transaction IDs
If you AVG Quantiy you get 10.69
If you do what you want to do you have to SUM Quantiy before DIVIDING by the distinct count of Transaction.
So your answer is:
Please mark this post as helpful or correct if it solves your issue.
I did read what you were saying and completely understood. And I responded, correctly, that there were 10 transactions and the average of those transactions was 13.9. Am I missing something?
Thanks for your help.