Re: Help with Calculation

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 04 Dec 2005 11:42:14 -0800
Message-ID: <1133725316.354107_at_jetspin.drizzle.com>


bobsacomano_at_yahoo.com wrote:
> 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

Without seeing the starting data I can't tell what you are actually trying to do.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Sun Dec 04 2005 - 20:42:14 CET

Original text of this message