the first block `TO_NUMBER(SUBSTR({notes},1,INSTR(...
# suiteanalytics
v
the first block
TO_NUMBER(SUBSTR({notes},1,INSTR({notes},',',1)-1))
you find the first occurrence, the second you find the second occurrence and sum
+TO_NUMBER(SUBSTR({notes},INSTR({notes},',',2)+1,INSTR({notes},',',3)-1))
and continue doing this based on the number of occurrences