I would like to provide my users the ability to use built in summaries using the summary icon on the column header. However if the column contains nulls in the cells the sumary form only contains the ability to count, max and min. is there a way to let it summarize all values it contains and ignore the nulls?
I figured it out. The Procedure that was providing the data was performing a
DECODE(A.EST,0,NULL,round((ABS(A.IP + A.IL + A.EP + A.EL - A.EST) / A.EST) * 100,2))) "Estimate Variance %"
if I wrap it in a to_number( ) the grid is able to summarize the values.