I was trying to get Col Quantile( :height, 0.5, :class) but it looks like the calculation would still take the excluded rows into consideration.
Is there a way to reject the excluded rows into Col Quantile calculation?
You can check for the row being excluded within the Col Quantile() function. Below is an example
Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << New Column( "Col Quantile Height by Age",
formula( Col Quantile(If(excluded(rowstate(Row())),., :height), 0.5, :age ) )
Whenever the excluded rowstate changes for the rows in the data table, the formula will calculate new values