Re: Help with Calculation

<bobsacomano_at_yahoo.com> wrote in message news:1133602293.582144.29870_at_g47g2000cwa.googlegroups.com
> I have a Discoverer report that lists the same order number on
> multiple rows with different product amounts for that order. I want
> to create a new order total column that adds the product amounts for
> each order number. I would like my report to look just like the
> below example. I'm a total amateur at Discoverer, so layman's terms
> would be
> greatly appreciated. Thanks.
>
> (new column)
> Order Number Amount Order Total
> 11111 100 300
> 11111 50 300
> 11111 25 300
> 11111 25 300
> 11111 100 300
> 22222 250 500
> 22222 150 500
> 22222 100 500

You didn't mention what Discoverer version you are using. Solution is simple - you have to use analytical group total function SUM(...) OVER (PARTITION BY ...). If you are using AS Discoverer, there is a calculation wizard that guides you: Insert formula from template -> Group Total -> Restart total at each change in... Received on Tue Dec 06 2005 - 09:38:22 CET