Create new columns that add data from existing columns to one fixed column

[#1]

Let's say I have one column with numeric-continuous data.  This data is my "reference" data.  I have n other columns with numeric-continuous data.  Is there a way to create an additional n columns where each of these new columns is a sum of the first "reference" data column with each of the n other columns?

[#2 · Accepted solution]

Hi, you can do this as follows:

1) From the main menu, select Cols > New Columns... and add N columns by typing that number into the Number of Columns to add box. If you like, add them as a group and type something into the Column Prefix box.

brady_brady_0-1677724839400.png

2) Highlight all the new columns, right-click in the column header area and select "Standardize Attributes"

brady_brady_1-1677724999170.png

3) Under Column Properties, use the drop-down to select Formula:

brady_brady_2-1677725017367.png

4) Select "substitute column reference" and then click Edit Formula:

brady_brady_3-1677725084550.png

5) Enter the first formula and click OK:

brady_brady_4-1677725126997.png

6) Uncheck the reference column checkbox. The input should look like below. Then press OK.

brady_brady_5-1677725202237.png

7) The results show formulas as desired:

brady_brady_6-1677725233201.png

Cheers,

Brady

[#3]

Thanks, this is exactly what I was trying to accomplish.