Re: Help with Calculation

[Quoted] The report that Discoverer generates for me are various columns (i.e. order number, product amount, dates, cost codes, etc.). I want to add a calculation (new column) that adds up all the product amounts for the same order number. So for instance, if there are three rows for order number 1234 and each row has a separate product amount of 100, 150, 200, then the new column will have the total of the product amounts in [Quoted] each row for that order number 450, 450, 450. I'm aware that a subtotal is one solution to this, but it won't work for what I need to do. I hope this clarifies. Received on Mon Dec 05 2005 - 18:27:34 CET