RE: Aggregate SUM

Posted in 1999

Russ_Evans@doh.state.fl.us — Tue, 6 Apr 1999 17:55:26 -0400 — source: Informix-list mailing list archive (1991-1998)

the aggregate function SUM automatically disregards null values. SELECT SUM(int1) from table will return 25 for the following table. table int1 char1 0 hi 2 hi 23 hi null hi -----Original Message----- From: david@temss2.isr.temple.edu [mailto:david@temss2.isr.temple.edu] Sent: Tuesday, April 06, 1999 3:06 PM To: informix-list@iiug.org Subject: Aggregate SUM when using the aggregste function (sum) in a report.... is there a way to place a conditional statemment within (i.e.) sum(col1 where col1 is not null)