Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 21, 2024 01:23 PM
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:
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?
Aug 22, 2024 07:34 AM
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
Aug 22, 2024 07:47 AM
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