Identifying Seat Count

I feel like I may have asked the listserv for help on this before, but I can’t recall what the solution might have been. I am trying to simply establish the formula to count all seats in my house…but everything I’m trying is returning a different number for every performance in the same venue.
 
My house count is 987 seats. But no matter what criteria I try, I am not seeing a consistent total seat count across performances (see screenshot below).
 
Table

Description automatically generated
 
Does anyone have advice on how to fix this? Thank you in advance!!
Parents
  • I appreciate the continued brainstorming! I actually think I’m going to submit a ticket – you were right to advise me to compare this to the House Manager. It looks like the missing seat count is almost entirely matching up with the number of tickets we have on payment plans…apparently those don’t show up in “Reserved, Unpaid” even though it would make sense for them to do so.
     
    Thanks again, Neil!
     
    Anh Le (she/hers/hers)
    Director of Marketing & PR
    OPERA THEATRE OF SAINT LOUIS
    email: ale@opera-stl.org
    phone: 314.963.4294 | mobile: 760.834.5926
    210 Hazel Ave St. Louis, MO 63119
     
     
Reply
  • I appreciate the continued brainstorming! I actually think I’m going to submit a ticket – you were right to advise me to compare this to the House Manager. It looks like the missing seat count is almost entirely matching up with the number of tickets we have on payment plans…apparently those don’t show up in “Reserved, Unpaid” even though it would make sense for them to do so.
     
    Thanks again, Neil!
     
    Anh Le (she/hers/hers)
    Director of Marketing & PR
    OPERA THEATRE OF SAINT LOUIS
    email: ale@opera-stl.org
    phone: 314.963.4294 | mobile: 760.834.5926
    210 Hazel Ave St. Louis, MO 63119
     
     
Children
No Data