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