Members   Search   Help    Register    Login   Home
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
Report message to a moderator
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
Report message to a moderator
Previous Topic:Digital Signature in XML reports (apps)
Next Topic:Comparing Columns
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 9 00:30:43 CST 2009

Total time taken to generate the page: 0.36906 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.