Discoverer question...

From: JASON <no email>
Date: Mon, 05 Aug 2002 22:21:48 GMT
Message-ID: <3d4efa5e.15917840_at_news.dslextreme.com>

I'd like to find a way in Discoverer to calculate 'weighted average'.

Given the following:

---

Price Quantity Extension (Price x Quantity)

6.00      10            60
2.00      60          120
-----    --------     -----------
????     70          180


=====================================

In the example above, I would like to show the 'weighted average' price under the 'Price' column, calculated by dividing the total of 'Extension' by the total of 'Quantity', that is, 180 divided by 70, or 2.57.

Can you please tell me how I can best do this in Discoverer.

Thanks.

Jason Received on Tue Aug 06 2002 - 00:21:48 CEST