Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
680
Summaries
posted

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?

Parents
No Data
Reply
  • 680
    Verified Answer
    Offline posted

    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.

Children
No Data