Home » Fusion Middleware & Colab Suite » Business Intelligence » Create Avg and "Grand" Avg in Answers as You would a Sum Total (BIEE, Version 10.1.3.4, Microsoft Windows Server 2003 R2)
Create Avg and "Grand" Avg in Answers as You would a Sum Total [message #407769] Thu, 11 June 2009 08:44 Go to next message
norah.wulff
Messages: 1
Registered: June 2009
Location: Cape Town, South Africa
Junior Member

Hi there

Do you know how to create an average and "grand" average in Answers as you would a Grand Total? There is only the option to use the aggregate sum, do you know how to instead use the aggregate avg? Discoverer has this feature but I can't seem to find it in Answers.

Any help would be greatly appreciated.

Kind regards
Norah Wulff
Re: Create Avg and "Grand" Avg in Answers as You would a Sum Total [message #410558 is a reply to message #407769] Sun, 28 June 2009 18:52 Go to previous message
monica365
Messages: 6
Registered: November 2008
Location: Argentina
Junior Member

Use set method (union) to add a request to get the Grand Avg. Select AVG as aggregation for each measure.

Hope it helps.
Monica
Previous Topic: Digital Signature in XML reports (apps)
Next Topic: Comparing Columns
Goto Forum:
  


Current Time: Thu Mar 28 09:43:25 CDT 2024