535603_en-US

liliconcom

I want to add formula to subtract 1st and 4th row, then 2nd and 5th row.. then 3rd and 6th row and so on..urgent please help!

Hi,

:RESULT is the column where I want to subtract row 1 and row 4, then row 2 and row 5 and so on until all the rows finishes. 

:TEST is currently an empty column where I want to store the results of :RESULT column

 

I tried the following script in the formula but it doesn't work? Not sure why?

 

:RESULT << Data Type( Numeric );
:TEST << Data Type( Numeric );
For( i = 1, i <= N Rows(), i++,
Abs( :RESULT[i] - :RESULT[i + 3] )
);

Scripting