Want to create a Virtual Column that will count the value of a column
Example Column [Email Address] Lets say i have 3 hot@hot.com, and 5 cool@cool.com
I want the virtual column to count the email in this column and tell me the number count.
I have tried Count(list([Email Address]) and i only list the 1 value
[Email Address] would have to be an ENUMLIST type column for count to work
Thank you for you response. Unfortunately i have this field as email address.
I donโt understand this example. Please show exactly what the data is. Are you wanting to count data in a single record, or across an entire Table?
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |