Im certain that Im just blanking on this one, nevertheless...
How can I find average ticket price for a production?
(short of going all math wizard on attendance by performance reports)
Thank you T2 all stars. (no we do not have T-stats, yes we plan to eventually)
Maybe there's a report for it - not sure off the top of my head. Here's a quick and dirty sql query that will give it to you. Assuming you're using lt_tkt_hist, and you'll want to check that your fields are named the same as it is a local table.
select AVG(tck_amt) from lt_tkt_hist where production_no = ####