Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Formula for precent with multi select field Information

272 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Kj0403
4 - Data Explorer
4 - Data Explorer

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?

2 Replies 2

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:

Pascal_Gallais_0-1724336450874.png

-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:

Pascal_Gallais_5-1724336889841.png

 

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

Pascal_Gallais_3-1724336730205.png

Pascal_Gallais_4-1724336762094.png

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

Pascal_Gallais_6-1724336947236.png

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

Pascal_Gallais_7-1724336993565.pngPascal_Gallais_8-1724337018018.png

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

Pascal_Gallais_9-1724337125116.png

Regards,

Pascal

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. 

Alexey_Gusev_0-1724338042118.png

 


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