Home » Developer & Programmer » Reports & Discoverer » Weighted Averages in with Subtotals in Discoverer
Weighted Averages in with Subtotals in Discoverer [message #88933] Fri, 20 June 2003 11:55 Go to next message
Ken
Messages: 50
Registered: April 1998
Member
When doing averages in subtotals, Discoverer is averaging averages.

I created a weighted calculation:

Weighted avg=sum(weighted factor*weighting item)/
sum(wieghting factor)

e.g.,
average price=sum(quantity*price)/sum(quantity)

does not patch the problem.

Any thoughts?

I've been playing with the analytical functions with no success.

Report message to a moderator

I did a search on this site [message #88934 is a reply to message #88933] Fri, 20 June 2003 13:26 Go to previous message
Ken
Messages: 50
Registered: April 1998
Member
There a posting by

usomasundaram@formfactor.com

with the same question a while back ago.

The webmaster appears to have purged that thread!!!

Report message to a moderator

Previous Topic: Utility available to generating oracle reports into excel
Next Topic: urgent How to call 9i Reports in server?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 20:36:12 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.