Hi,
I have a text/string with numbers separated by comma. I split this text by comma and i want to SUM the values. I know the SPLIT function returns a list of strings. Is there a way to transform a list of strings into a list of numbers to be able to sum them?
Note: i donโt use virtual columns. Only for references. My app is big and i avoid using VCs.
Thank you!
You could try using an action to set a column of type List of Number from the existing column, which is the same approach Iโd suggest with a virtual column.
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |