Subtract between multiple columns
dt = current data table();
For ( i=0 , i<8, i++,
dt << new column( "RESULT",
Numeric,
"Continuous",
For (x=1, x<50, x++,
Formula(Column(3+i)[x]-Column(2+i)[x]),
));
);
I would like to subtract data between multiple columns, i have tried the script above but its not working. Is there a more effective way to do it?Expected result:result = data2 - data1result1 = data4 - data3result2 = d...