Re: Compute AVG and excluding 0 values
From: Tony Damon <bfntd_at_aimnet.com>
Date: 1996/03/20
Message-ID: <4iphu0$t21_at_news.aimnet.com>#1/1
Date: 1996/03/20
Message-ID: <4iphu0$t21_at_news.aimnet.com>#1/1
Stephen McClure (mcclure_at_primenet.com) wrote:
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
: Is there anyway to exclude rows with 0 values from a "compute avg on"
: statement?
:
BREAK ON REPORT
COLUMN FOO NULL '0'
Tony Damon
Received on Wed Mar 20 1996 - 00:00:00 CET