Hi all,
I have a widget in my Subscriptions dashboard that tracks a daily running total for each of our subscription packages. The problem I'm encountering is that the data rarely matches or even comes close to other reports that we use daily. Some of our smaller packages, Jazz for example, are usually pretty close but our Broadway season is always way off. Wondering if it's not counting package fees or something else that I'm not considering. This is the formula I'm currently using for revenue: RSUM([Total Ticket Original Value])
I've tried a few different ticket value metrics, wondering if there is another piece that I am missing.
Thanks for any advice!
Hi Hilary - You may want to try Tickets Paid. Original and home value is complicated, but basically original value is counting the value of the ticket BEFORE the price was discounted or increased. I hope that helps.
That didn't quite work. I did adjust to RSUM([Total Ticket Paid/Reserved Value]+ [Total Ticket Unpaid Amount]) and that got me a little closer, but I'm still short by about $300k (for my BW season).