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)
> *************************************************************