Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Weighted average in BO?

Status
Not open for further replies.
gshadz37

gshadz37

Technical User
Mar 21, 2005
102
US
Hi,

I am struggling to find a way to perform a weighted average of two columns in a Webi report. Similar to the functionality of sumproduct in Excel. Can anyone tell me if it's possible? If so, how?

Thank you.
 
Sort by date Sort by votes
There is nothing built-in for this. However, you can simply add your own column that does the calculation.

Steve Krandel
Intuit
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Boggy777
  • Locked
  • Question
Custom Element menu greyed out in WebI editing screen in BI 4.3 SP2
Replies
0
Views
289
Boggy777
Boggy777
TracieN
  • Locked
  • Question
Previous Function in Webi
Replies
1
Views
346
kray4660
kray4660
Clappy2000
  • Locked
  • Question
Date Prompt in Freehand SQL excluding the Time (Web Rich Client Report)
Replies
0
Views
269
Clappy2000
Clappy2000
harshalsoft
  • Locked
  • Question
Ranking on Cross tab report in BO webi
Replies
1
Views
222
harshalsoft
harshalsoft
padupadu
  • Locked
  • Helpful tip
variable code in webi report XI R3 from BO object metadata
Replies
2
Views
197
padupadu
padupadu

Part and Inventory Search

Sponsor

Back
Top