Auto-populate Multi-Select Field From Linked Recor...

[Kj0403]

Hello, 

I have a multi select field, with 5 different options that by person you can select 1 to all 5 items for.  I am trying to create a formula where it looks at all the people (say 20 people) and sees out of all of them how many have X as an option selected from this multi select field.  

For Example:

• Person 1: Has X
• Person 2: Has X,Y
• Person 3: Has Y

So then If I am trying to show what the percentage is of people who know X, it would output _% 

Does this make sense?  Is this possible?

[Pascal_Gallais-]

Hello,

You can link your "person" table to a recap table with a single line to achieve this.

-1- Create a recap table with a single line and just the primary key field "recap_id", type Number, value 1:

-2- In your "person" table, add "link to another record" field, link it to table recap, and set the value to 1 for all lines:

-3- Go back to "Recap" table and add a count record to get the total number of persons:

-4- Add another Count record to get the number of persons who selected Option A:

-5- Add a formula field to compute the %:

You can then duplicate fields "Nb Option A" and "Option A %" and modify them for Option B, C...

Regards,

Pascal

[Alexey_Gusev]

Hi,
You should create 'totals' table containing 1 record and link it to all records of your table.
Then create count fields for each item. 

Then , switch back to you table and you can use these numbers from 'totals' using Lookup and/or Rollup with formulas