I have a query where I sum a value sum(U_CPA_NUMER), this value can be a NULL or Float values. If a null is one of the values my result is null. I have tried using a case statement,
sum(case when u_cpa_numer is null then 0 else u_cpa_numer end) but this yields a 0 value only.
I tried excluding null values for this field in my where clause but this wacks out the whole query. Please help.