• Replies 5 replies
  • Subscribers 412 subscribers
  • Views 34 views
  • Users 0 members are here
Related

Inconsistent totals in Event Listing Report

Former Member
Former Member $organization

When we run the Event Listing Report, save it to Excel, and add the totals in the “recd_amt” and 
“num_attendees” columns, we are getting inflated totals for the number of attendees and amount paid. 

For example if a constituent brings 2 guests, we enter the Number of attendees as 3 on the Events screen, along with the amount paid, and then double click and list the guests on the Event Attendees screen.  The Event Listing report displays the correct grand total of 3 attendees when it is viewed onscreen. However, when the report is saved to Excel, that constituent is listed three times, each time with 3 attendees, so that the grand total of attendees under the constituent's name becomes 9.

Is there any way to get the correct totals without having to manually remove the duplicate rows from the Excel report? We often want this report rather than the Special Events Receipt Listing Report, in order to report on guest names and the Notes field.

Any advice would be most appreciated!

Parents
  • $organization

    I use the Count function instead of the Sum Function to get the total attendees.

    ~Sadie

  • $organization in reply to Sadie Treese (Past Member)
    That's better than mine! Of course both this solution and my solution (to replace all counts with 1) are only accurate if every guest has a line in the attendees window.

    With regard to the recd_amount...I'm drawing a blank, because it's been a while. I know that a the 2008 conference in Nashville there was a great Special Events presentation. Dale Aucoin was one of the presenters and I know he addressed the Event Listing report. If you haven't already, I would check that out.

    Good luck!


    ________________________________________
    From: Tessitura Development Forum [forums-development@tessituranetwork.com] On Behalf Of Sadie Treese [bounce-sadietreese3511@tessituranetwork.com]
    Sent: Tuesday, March 30, 2010 7:56 AM
    To: Cate Czerwinski
    Subject: Re: [Tessitura Development Forum] Inconsistent totals in Event Listing Report

    I use the Count function instead of the Sum Function to get the total attendees.

    ~Sadie
    From: Maureen Woodall
    Sent: 3/25/2010 7:37:25 PM

    When we run the Event Listing Report, save it to Excel, and add the totals in the “recd_amt” and
    “num_attendees” columns, we are getting inflated totals for the number of attendees and amount paid.

    For example if a constituent brings 2 guests, we enter the Number of attendees as 3 on the Events screen, along with the amount paid, and then double click and list the guests on the Event Attendees screen. The Event Listing report displays the correct grand total of 3 attendees when it is viewed onscreen. However, when the report is saved to Excel, that constituent is listed three times, each time with 3 attendees, so that the grand total of attendees under the constituent's name becomes 9.

    Is there any way to get the correct totals without having to manually remove the duplicate rows from the Excel report? We often want this report rather than the Special Events Receipt Listing Report, in order to report on guest names and the Notes field.

    Any advice would be most appreciated!



    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Reply
  • $organization in reply to Sadie Treese (Past Member)
    That's better than mine! Of course both this solution and my solution (to replace all counts with 1) are only accurate if every guest has a line in the attendees window.

    With regard to the recd_amount...I'm drawing a blank, because it's been a while. I know that a the 2008 conference in Nashville there was a great Special Events presentation. Dale Aucoin was one of the presenters and I know he addressed the Event Listing report. If you haven't already, I would check that out.

    Good luck!


    ________________________________________
    From: Tessitura Development Forum [forums-development@tessituranetwork.com] On Behalf Of Sadie Treese [bounce-sadietreese3511@tessituranetwork.com]
    Sent: Tuesday, March 30, 2010 7:56 AM
    To: Cate Czerwinski
    Subject: Re: [Tessitura Development Forum] Inconsistent totals in Event Listing Report

    I use the Count function instead of the Sum Function to get the total attendees.

    ~Sadie
    From: Maureen Woodall
    Sent: 3/25/2010 7:37:25 PM

    When we run the Event Listing Report, save it to Excel, and add the totals in the “recd_amt” and
    “num_attendees” columns, we are getting inflated totals for the number of attendees and amount paid.

    For example if a constituent brings 2 guests, we enter the Number of attendees as 3 on the Events screen, along with the amount paid, and then double click and list the guests on the Event Attendees screen. The Event Listing report displays the correct grand total of 3 attendees when it is viewed onscreen. However, when the report is saved to Excel, that constituent is listed three times, each time with 3 attendees, so that the grand total of attendees under the constituent's name becomes 9.

    Is there any way to get the correct totals without having to manually remove the duplicate rows from the Excel report? We often want this report rather than the Special Events Receipt Listing Report, in order to report on guest names and the Notes field.

    Any advice would be most appreciated!



    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Children
  • $organization in reply to Cate Czerwinski
    In the report, the total for the number of attendees is summing the attendees column ONCE for each event attendee, for which there may be a number of additional rows for guests in the data. All attendees and guests are stored as individual rows in the database, but the value stored in the attendees column may be different than the count of named attendees.

    So in this example:

    Name Attendees
    Ryan Creps2
    Beth Creps2(Guest of Ryan Creps)

    The total is "2", not "4", as Beth (my lovely wife) is my guest.
    Hope that helps.
    -Ryan

    -----Original Message-----
    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Cate Czerwinski
    Sent: Tuesday, March 30, 2010 10:16 AM
    To: Ryan Creps
    Subject: RE: [Tessitura Development Forum] Inconsistent totals in Event Listing Report

    That's better than mine! Of course both this solution and my solution (to replace all counts with 1) are only accurate if every guest has a line in the attendees window.

    With regard to the recd_amount...I'm drawing a blank, because it's been a while. I know that a the 2008 conference in Nashville there was a great Special Events presentation. Dale Aucoin was one of the presenters and I know he addressed the Event Listing report. If you haven't already, I would check that out.

    Good luck!


    ________________________________________
    From: Tessitura Development Forum [forums-development@tessituranetwork.com] On Behalf Of Sadie Treese [bounce-sadietreese3511@tessituranetwork.com]
    Sent: Tuesday, March 30, 2010 7:56 AM
    To: Cate Czerwinski
    Subject: Re: [Tessitura Development Forum] Inconsistent totals in Event Listing Report

    I use the Count function instead of the Sum Function to get the total attendees.

    ~Sadie
    From: Maureen Woodall
    Sent: 3/25/2010 7:37:25 PM

    When we run the Event Listing Report, save it to Excel, and add the totals in the “recd_amt” and
    “num_attendees” columns, we are getting inflated totals for the number of attendees and amount paid.

    For example if a constituent brings 2 guests, we enter the Number of attendees as 3 on the Events screen, along with the amount paid, and then double click and list the guests on the Event Attendees screen. The Event Listing report displays the correct grand total of 3 attendees when it is viewed onscreen. However, when the report is saved to Excel, that constituent is listed three times, each time with 3 attendees, so that the grand total of attendees under the constituent's name becomes 9.

    Is there any way to get the correct totals without having to manually remove the duplicate rows from the Excel report? We often want this report rather than the Special Events Receipt Listing Report, in order to report on guest names and the Notes field.

    Any advice would be most appreciated!



    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!


    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums.

    In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
  • $organization in reply to Ryan Creps (Past Staff Member)

    Hello all,

    We are having some similar confusion over the totals (which kind of make sense), but also in that the attendees and their guests seem to be pulled for the report in inconsistent ways.

    Some pull like this:

    Reynolds Jim   ID#1234   2 Attending

    Caryn Reynolds

     

    Some pull like This:

    Reynolds Jim   ID#1234   2 Attending

    Caryn Reynolds

    Jim Reynolds ID#1234

     

    Some Like This:

    Reynolds Jim   ID#1234   2 Attending

    Caryn Reynolds

    Reynolds Jim   ID#1234   2 Attending

    Jim Reynolds

     

    I am digging around to see if there's a difference in how things are entered, but so far the Event Attendees all look like they are entered in the same way.

    Any thoughts or suggestions are highly appreciated!

    Jim