Re: Compute AVG and excluding 0 values

Stephen McClure (mcclure_at_primenet.com) wrote:
: Is there anyway to exclude rows with 0 values from a "compute avg on"
: statement?
:

Just a guess...

use a DECODE(column,0,NULL) FOO for the column in question. I'm guessing AVG will ignore null values. You could SET NULL 0 or add a NULL attribute in a COLUMN command so that the detail line you still display with a zero.

COMPUTE AVG OF FOO ON REPORT
BREAK ON REPORT
COLUMN FOO NULL '0' Tony Damon Received on Wed Mar 20 1996 - 00:00:00 CET