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(
...