Adition of numbers in a column

Hello everibody!
Is there any possibility of addition the numbers likes on the New column D on image?

How was that column created? Does the Rollup column on top of “New Column D” allow you to sum it?

If not, I guess it’s easier to just use JavaScript to act on the original column, which might be a comma-delimited list.

Yes, it comes from a column that is separated by commas.

A rollup won’t work, because the source is a string.
So as @ThinhDinh suggested, the simplest approach is to use JavaScript:

return p1
  .split(', ')
  .map(num => Number(num))
  .reduce((acc, num) => acc + num, 0);
2 Likes

Thank you very much for your help, I was never going to solve it.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.