Hi, all-
I see in the documentation for the finance cube the definitions for ticket paid amount and transaction amount, but I am wondering why these would be different?
Can anyone please elaborate why I might see a difference between the two?
Thanks!
Rachel
https://www.tessituranetwork.com/Help_System/Tessitura.htm#Tessitura%20Analytics/Data%20Dictionary/Finance%20Cube.htm
Ticket Paid Amount
Just a thought but Fees, Gift Certificates & Contributions are also included in a total transaction amount.
Thank you, Heath. I would then think the transaction amount would be greater than the paid amount, but that doesn't seem to be the case. I'll keep digging, but appreciate your help!
An important thing to keep in mind is that not all transactions involve tickets. So for example, if a transaction is a contribution, the transaction amount will be whatever it is and the ticket paid will be zero. If a transaction is a ticket purchase, then the cont amt would be zero, and the transaction amt and ticket paid amt would be whatever they are. The exact reason for differences in what you're seeing depends on a bit on your filters and how you're grouping the data, but hopefully that sheds some light on why both measures are in there and why they're not necessarily interchangeable.
Thank you! Your explanation is quite helpful.
For this particular case, it ended up being unposted batches which were being excluded in the transaction amount, but included in the paid amount.
Thanks for everyone's help!