View Incident Report

Serious

Reported By: Clive Bennett
Reported On: 11/2/2004
For: Version 4.14 Build 1

# 1886 SQL RUNSUM Function Not Working Correctly With NULL Values in Column Being Summed

I have a table with 24 rows in it, my query produces 12 rows the column value has null values for all but the 4 row in this result set
If I do a runsum on this column it doesnt keep the total moving forward unless I place a non-zero value in the first row of this result set.

select runsum(value),period from tempeva_cum 
where eva_code = 63 group by period

workaround:

select runsum(coalesce(value,0.0)),period from tempeva_cum where eva_code = 63 group by period

Resolution

Fixed Problem on 12/7/2004 in version 4.16 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap