Reported By: Clive Bennett Reported On: 11/2/2004 For: Version 4.14 Build 1
# 1886SQL 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
ResolutionFixed Problem on 12/7/2004 in version 4.16 build 1