Home » Developer & Programmer » Reports & Discoverer » Weighted Average in Discoverer -Urgent
Weighted Average in Discoverer -Urgent [message #88493] Wed, 09 October 2002 09:15 Go to next message
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
Re: Weighted Average in Discoverer -Urgent [message #88503 is a reply to message #88493] Thu, 17 October 2002 07:00 Go to previous messageGo to next message
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,
Re: Weighted Average in Discoverer -Urgent [message #88505 is a reply to message #88503] Sat, 19 October 2002 06:43 Go to previous messageGo to next message
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
Re: Weighted Average in Discoverer -Urgent [message #88579 is a reply to message #88493] Sun, 24 November 2002 23:34 Go to previous message
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.
Previous Topic: result of the query (reports6i) from the forms6i
Next Topic: Summary Report using group by
Goto Forum:
  


Current Time: Fri May 27 16:15:54 CDT 2022