Re: SUM() not working as expected

Wow... ROLL UP looks great! Thanks. - Charles On Mar 4, 2004, at 5:28 AM, Victoria Reznichenko wrote: charles kline <[EMAIL PROTECTED]> wrote: Oh I see... so how would I get balance_amt to have a running balance? - You can calculate it in your application - You can run an additional query - From

Re: SUM() not working as expected

charles kline <[EMAIL PROTECTED]> wrote: > Oh I see... so how would I get balance_amt to have a running balance? - You can calculate it in your application - You can run an additional query - From version 4.1.1 you can use WITH ROLLUP modifier with GROUP BY clause to get summary info: htt

Re: SUM() not working as expected

Oh I see... so how would I get balance_amt to have a running balance? Thanks, Charles On Mar 3, 2004, at 11:20 AM, Victoria Reznichenko wrote: charles kline <[EMAIL PROTECTED]> wrote: Hi all, Just trying to figure out why the SUM() in this query is not returning the sum, but is returning the sam

Re: SUM() not working as expected

charles kline <[EMAIL PROTECTED]> wrote: > Hi all, > > Just trying to figure out why the SUM() in this query is not returning > the sum, but is returning the same value that signed_amt contains. > Anyone have a clue? Thanks for any help :) > > Here are the results I am getting: > > id | signed

SUM() not working as expected

Hi all, Just trying to figure out why the SUM() in this query is not returning the sum, but is returning the same value that signed_amt contains. Anyone have a clue? Thanks for any help :) Here are the results I am getting: id | signed_amt | balance_amt | entry_dtm ---++---