I'm having trouble getting what I think should be two sets of numbers to equal out. On the one hand I have "Capacity", on other I have Sold, Resold, Comp, Held, and Available, defined thusly:
Capacity
sum([Seat Count])
Sold
( sum([Ticket Count]), [Price Type Category] , [Resale Status1] )
Price Type Category: -Comp
Resale Status1: - Resale
Resold
( sum([Ticket Count]), [Resale Status1] )
Resale Status1: Resale
Comp
( sum([Ticket Count]), [Price Type Category1] )
Price Type Category1: Comp
Held
( sum([Total Seat Count]), [Seat Hold Code] ) - ( sum([Total Ticket Count]), [Seat Hold Code] )
Seat Hold Code: -(none)
Available
sum([Seat Unsold Count]) - ( [Total Seat Unsold Count] , [Seat Hold Code] )
I'm off, but not by much. For example:
[Perf 1]
Capacity: 1732
Sold: 735; Resold: 0; Comp: 74; Held: 641; Available: 283 (Total 1733)
Pretty close, but
[Perf 2]
Capacity: 649
Sold: 611; Resold: 7 (ignore); Comp: 19; Held: 9; Available: 22 (Total 661)
I'm still digging around, but it's not obvious to me where I'm going wrong. An old custom report is closer on these figures: it shows lower sales and higher resold.
Okay, well the next step was to just break one performance out by Seat Id. In theory we shouldn't have have too many buckets filled in for any one seat, with the exception of resales.
Now, for starters, it looks like I'm guaranteed to be off by one on every show: and I do see to be off by at least one on every show (based on the the old report at least):
With resales I'm seeing a few, at least, marked as sold and resold (good) and comp, which is curious, but at least I have some seat Ids to research further.
That Seat Id 0 "sale" was in fact a rogue unseated ticket floating around, so that's actually expected (I think).