Convert LIST of strings to numbers


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.