BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: Upcoming Events: IBIS 2018: Jun 18, BI & HANA 2018 Prague: Jun 29.

problem in standard deviation & %Coefficient of variatio

Search this topic... | Search Desktop Intelligence... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Desktop Intelligence  Previous TopicPrint TopicNext Topic
Author Message
Principal Member
Principal Member

Joined: 29 Nov 2004
Posts: 104

PostPosted: Fri Feb 18, 2005 10:40 am 
Post subject: problem in standard deviation & %Coefficient of variatio

I have two issues:
1. Standard Deviation
I want to calculate the standard deviation for a sample for which i have i created a stdddev(sample) measure object in the universe.
THe problem is when i run the report for stddev i get the values of each sample as follows:
At the end(last row) the value is not related to any sample. i am unable to figure out what is this value. i ran the query on my DB and i am getting the correct values but not the last row value which is neither the avg,sum or any other function i can think of. anyone had a similar experience. pls let me know.
2. The %Coefficient of Variation(%Cv)
Again when i calculate the %CV i am facing the same problem.i get a high value in the last row which i am not able to figure out.
The %CV=(Stddev(sample)/Avg(sample))*100

Thanks in advance
BO 5.1.3 Full client and Oracle8i
Back to top
Forum Associate
Forum Associate

Joined: 15 Aug 2002

Posts: 544
Location: Ottawa

PostPosted: Wed Feb 23, 2005 5:12 pm 
Post subject: Re: problem in standard deviation & %Coefficient of vari

You need to use calculation contexts in both cases. I've used in Block because I don't know the dimensions you're using. You may need to alter this depending on what you're doing however (eg do you want to cross section breaks or report breaks).

1. Standard Deviation:
Populate a column with the following logic:
=StdDev(<measure>) In Block

The sample are the measure values in the block. You'll notice that StdDev(<measure>) , when it is placed in the footer, matches the column value of =StdDev(<measure>) In Block .

2. Convert your formula with calculation contexts to use summary metrics.

Average = Average(<measure>) In Block
Std dev = StdDev(<measure>) In Block

Hope this helps.


Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Desktop Intelligence  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0103 seconds using 17 queries. (SQL 0.0031 Parse 0.0002 Other 0.0071)
CCBot/2.0 (
Hosted by | Terms of Service
phpBB Customizations by the
Shameless plug for Moments of Light Logo