How do I select the different values that are separated by commas by default in an enumlist called [Kids].
An expression with LEFT only selects the left-most and right-most values.
LEFT([Kids], FIND(",", [Kids]&",") - 1)
Thanks!
User | Count |
---|---|
36 | |
8 | |
3 | |
2 | |
2 |