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 <[email protected]> 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 <[email protected]> > 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: [email protected] > 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" <[email protected]> > Subject: Re: how best to calculate percentage of people who multiple > conferences - using FileMaker 11 > > >> On 2014 Nov 22, at 02:57, Tami Williams <[email protected]> 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) > *************************************************************
