Sum of numbered columns

[richters]

Hi all,

is there a possibility to sum up or concat numbered columns?

I implemented a loop which creates columns named like : col_0, col_1, ...col_x

I know the number of created columns by a variable (x).

Does anyone know how to work with a flexible number of columns?

Thank you!

[Gysbert_Wassenaar · Accepted solution]

Maybe something like rangesum($(=concat( 'col_'&ValueLoop(1,x),',')))

[richters]

I used a construction like this:

LET x = 10;

LET vCols = 'rangesum(col_1' ;

for i = 2 to $(x);

LET vCols = '$(vCols)' & ', col_' & $(i);

next

SET vCols = $(vCols));

Thank you!