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
  • Thanks for the reply, Neil! For the widget, should I try to filter to only a hold code of none?
    Graphical user interface, application

Description automatically generated
     
    If so, those two formulas gives me pretty weird numbers… and again, the sum varies widely per performance.
     
    Table

Description automatically generated
     
    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
     
     
  • $organization in reply to Anh Le

    It depends on what holds you have (if any). The total seat count would be the ticket count + seat unsold count. Also, sometimes it displays the sum of something as the total. As in, the SUM(Ticket Count) is the same as [Total Ticket Count].

    I'd start there and then start adding hold codes. Maybe someone has added some that you didn't know about.

Reply
  • $organization in reply to Anh Le

    It depends on what holds you have (if any). The total seat count would be the ticket count + seat unsold count. Also, sometimes it displays the sum of something as the total. As in, the SUM(Ticket Count) is the same as [Total Ticket Count].

    I'd start there and then start adding hold codes. Maybe someone has added some that you didn't know about.

Children