Average the first 100 rows and the last 100 rows of a JMP column.
I have a noisy curve where I need to take average of the extremes and compare to the minimum value. Thought this would work but doesn't.
Col Mean( :Column_Name W[Index( 1, 100 )] ) + Col Mean( :Column_Name[N Rows() - 99 :: N Rows()] )
/ 2