Error during command authentication.
Error - unable to initiate communication with LISTSERV (errno=10061, phase=CONNECT, target=127.0.0.1:2306). The server is probably not started.
Tami, please correct this summation: - Starting from the POV of a given year (2012 in your example), the user can pick that year and up to 3 other years; - You first want the number -- 'theMultiples'-- of people who have attended all of the checked (I'm assuming a checkbox, but that may not be right) years; - Then you want to divide 'theMultiples' by the total number of attendees for the given year. Let's call that number 'theAttendees'; - So you want theMultiples/theAttendees; - The TYPE isn't a factor. Is that correct? John Weinshel On 11/22/14, 9:07 PM, "Tami Williams" <[log in to unmask]> wrote: >1 person = 1 TYPE of registration record per year. > >1 person can have 1 type A registration for 2010 and 1 type B >registration for 2010 and 1 type A registration for 2012. > >Need to find > >> how many of the 2010 attendees also attended the 2012 conference, >>divided by the total 2012 attendance > > >Thanks in advance. > > > > >On Nov 22, 2014, at 6:00 PM, FMPRO-L automatic digest system ><[log in to unmask]> wrote: > >> There are 2 messages totaling 210 lines in this issue. >> >> Topics of the day: >> >> 1. how best to calculate percentage of people who multiple conferences >>- >> using FileMaker 11 (2) >> >> ---------------------------------------------------------------------- >> >> Date: Sat, 22 Nov 2014 03:57:17 -0500 >> From: Tami Williams <[log in to unmask]> >> Subject: how best to calculate percentage of people who multiple >>conferences - using FileMaker 11 >> >> I have a Filemaker 11 database with People related to Conference >>Registration. >> >> 1 person may have 1 or more conference registration records. >> >> >> What is the best way (calc/script) to answer this question: >> >> >> What percent of people attended the 2010 and 2012 conference? >> >> >> (Note: the user would pick a series of years (2-4) and want the percent >>that attended all) >> >> >> Thanks in advance. >> >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >> "It's better to burn out than to fade away." >> >> Tami Williams >> Creative Computing >> Let us help you make frustrating, costly, and inefficient processes >>more efficient, less costly and scalable. >> Lasso, MySQL and FileMaker specialists. >> >> Tel/Fax: 770.457.3221 >> E-Mail: [log in to unmask] >> Web: http://www.asktami.com/ >> LinkedIn: http://www.linkedin.com/in/asktami >> Twitter: http://twitter.com/asktami >> iChat/AIM/Skype: tamiwilliamsusa >> >> FileMaker Business Alliance Member | Lasso Professional Alliance Member >>| Certified Lasso Developer | FileMaker 11, 12 & 13 Certified Developer >> >> ------ >> >> If you want to receive sporadic email from Creative Computing regarding >>news at the company and announcements about upcoming Lasso webinars and >>online classes, please opt-in at http://tinyurl.com/yj7eqlg >> >> ------------------------------ >> >> Date: Sat, 22 Nov 2014 09:44:30 -0600 >> From: "Richard S. Russell" <[log in to unmask]> >> Subject: Re: how best to calculate percentage of people who multiple >>conferences - using FileMaker 11 >> >> >>> On 2014 Nov 22, at 02:57, Tami Williams <[log in to unmask]> wrote: >>> >>> I have a Filemaker 11 database with People related to Conference >>>Registration. >>> >>> 1 person may have 1 or more conference registration records. >> >> Need more detail here. Do they have just 1 registration record PER >>YEAR, or can they have multiple registration records in a single year >>(say, 2 1-day-only memberships instead of a single full-week membership, >>or perhaps a separate registration for a banquet in addition to a >>general membership)? >> >>> What is the best way (calc/script) to answer this question: >>> >>> >>> What percent of people attended the 2010 and 2012 conference? >> >> Do you mean how many of the 2010 attendees also attended the 2012 >>conference, divided by the total 2012 attendance? Or the other way >>around? >> >>> (Note: the user would pick a series of years (2-4) and want the >>>percent that attended all) >>> >>> >>> Thanks in advance. >> >> ------------------------------ >> >> End of FMPRO-L Digest - 18 Nov 2014 to 22 Nov 2014 (#2014-48) >> *************************************************************