MARIO GUERRERO
Grasshopper
Points: 11
More actions
April 23, 2004 at 8:49 am
#84177
I need average a field, but I don't want to include ceros or nulls.
I tried with sum() and count() but I can't discriminate ceros on the count() function. Do you Have idea?(
Antares686
SSC Guru
Points: 125444
April 23, 2004 at 7:20 pm
#504111
DO a case in you count and sum like so
(CASE WHEN column = 0 THEN null ELSE value END)
By changing to a null the agregate will eliminate the nulls.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply