Icon View Incident Report

Serious Serious
Reported By: Clive Bennett
Reported On: 1/30/2004
For: Version 4.02 Build 1
# 1559 SQL RUNSUM Aggregate Function Returning the Same Result as the SUM Aggregate Function

The runsum function in v4.02 doesnt work anymore ie not cumulative.

select RUNSUM(value),period from rpt_generic_detail group by period

Produces the same results as

select SUM(value),period from rpt_generic_detail where group by period

Resolution Resolution
Fixed Problem on 2/6/2004 in version 4.03 build 1