Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread RUNSUM doesnt work correctly in 4.23 B2
Wed, Apr 5 2006 7:11 PMPermanent Link

"Clive"
Tim,
The RUNSUM function doesnt appear to be working correctly in 4.23 B2

select sum(value),runsum(value),period from rpt_generic_detail group by
period order by period

Produces seemingly random numbers for RUNSUM

If I remove the ORDER BY clause the summing is correct. I have checked this
in a previous version and it works correctly with the ORDER BY

I have reverted back to 4.22 as a workaround.

Thanks
Clive

Wed, Apr 5 2006 7:24 PMPermanent Link

"Clive"
I went to Version 4.22 B6 and problem is in this version also, so went back
to 4.22 B4 and its ok in this.

I have submitted incident 2180 for this

Thanks
Clive.

"Clive" <dd@dddd.com> wrote in message
news:85FBDAB0-F2FF-4C3E-A993-E4FF14C25003@news.elevatesoft.com...
> Tim,
> The RUNSUM function doesnt appear to be working correctly in 4.23 B2
>
> select sum(value),runsum(value),period from rpt_generic_detail group by
> period order by period
>
> Produces seemingly random numbers for RUNSUM
>
> If I remove the ORDER BY clause the summing is correct. I have checked
> this in a previous version and it works correctly with the ORDER BY
>
> I have reverted back to 4.22 as a workaround.
>
> Thanks
> Clive
>

Thu, Apr 6 2006 4:38 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Clive,

<< I have submitted incident 2180 for this >>

I still need some further info, so please check your email.

Thanks,

--
Tim Young
Elevate Software
www.elevatesoft.com

Thu, Apr 6 2006 4:58 PMPermanent Link

"Clive"
I have replied and attached table with SQL and myresults in a text file.

Thanks
Clive.

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:CDE7C66E-DA1C-42EC-B00A-10DA130D32A2@news.elevatesoft.com...
> Clive,
>
> << I have submitted incident 2180 for this >>
>
> I still need some further info, so please check your email.
>
> Thanks,
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
>

Image