Hi emma,
As your formula has essentially double-loop, you probably need to save the intermediate result in an
temporary column, and run a script similar to the following sample:Da=1;
NN=5;
for(k=1; k<=NN; k++) {
for(n=1; n<=NN; n++)
col(Intermed)[n]=col(I)[n*Da]*exp(col(kDv)[k]*n*Da);
sum(col(Intermed));
col(S)[k]=sum.total;
}
Here, Sum function takes this intermediate column as the argument, and it produces the basic statistics,
including the total (in the sum.total object).
You can put the script in the "Before Formula Script" box in the Set Column Values tool to take advantage
of recalculation as in the following screenshot:
Hope this helps.
--Hideo Fujii
OriginLab
sums in "set column values"
Posted - 10/30/2013 : 06:02:30 AM
