Assume you have a total of 100 items and a multi-select field that allows you to select from a set of values. You want to find out what percentage of the total is represented by the selected values.
Example Scenario
+1
+31Could you provide an example of this and what you would want the output to be? For example, is the data in the screenshot below set up the way you expect? If it is, what would some examples of output be?
+17- Employee
Use a "reporter" field. This is a linked record to a new table called reporter. Each one of your items will link to "reporter." In reporter you can use a "count" field to count the items that use select A, select B, etc. as a percent of the total.
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.