Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

AVG function with Rank or TopN

ArborifficSep 16 2009 — edited Sep 16 2009

Has anyone figured out a workaround for calculating the Average for a ranked rowset?

Basically, we want to calculate the average for top 20 products. We calculate a rank for each product using TOPN.

However, when using the AVG or similar functions to get the average, it always divides by the entire dataset, not just the top 20.

any insight would be appreciated.

thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 14 2009

Added on Sep 16 2009

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

1 comment

435 views