OraFAQ Forum: Reports & Discoverer » Weighted Average in Discoverer -Urgent

Home » Developer & Programmer » Reports & Discoverer » Weighted Average in Discoverer -Urgent

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Weighted Average in Discoverer -Urgent [message #88493]

Wed, 09 October 2002 09:15

Uma Somasundaram
Messages: 3
Registered: October 2002

Junior Member

Hi

Need to calculate weighted average for the data on the screen eg
qty amt
10 100
5 170
6 180
-- -----
21 450
-- ----
weighted average =450/21=21.42. How can this be achieved ?

Right now the Discoverer gives us the flexiblility to only calculate the average, which is = 450/3=150.

Thanks in advance.

Reagards,
-Uma

Report message to a moderator

Re: Weighted Average in Discoverer -Urgent [message #88503 is a reply to message #88493]

Thu, 17 October 2002 07:00

Amit Sheth
Messages: 3
Registered: October 2002

Junior Member

Hi !

You can create the following calculation:

sum(qty * amt)/sum(qty)

That should solve your problem.

Regards,

Report message to a moderator

Re: Weighted Average in Discoverer -Urgent [message #88505 is a reply to message #88503]

Sat, 19 October 2002 06:43

Amit Sheth
Messages: 3
Registered: October 2002

Junior Member

I have not been able to find a way to solve the issue mentioned by you. Give me a day / two, I will get back.

Regards,

Amit

Report message to a moderator

Re: Weighted Average in Discoverer -Urgent [message #88579 is a reply to message #88493]

Sun, 24 November 2002 23:34

Balan Anil Kumar
Messages: 5
Registered: November 2002

Junior Member

Hi Uma..

Did u get the result for this.. i have the same prob like that.. can u please help me

Hi,

I want to display distinct Total for supplier in report.
because we have only 2 suppliers

Month Supplier Amount
------ -------- ------
Jan'02 1 100
Feb'02 2 100
Mar'02 1 100
Apr'02 1 100
May'02 2 100
------- -----
Total 7 500

How can I show 2 instead of 7 in supplier's total

Thanks
Anil.

Report message to a moderator

Previous Topic:	result of the query (reports6i) from the forms6i
Next Topic:	Summary Report using group by

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 16:38:53 CDT 2024