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

Register | Login 

 
Lead By Knowing (Opens a new window)  

General Notice: No events within the next 45 days.

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
Ram31
Principal Member
Principal Member



Joined: 29 Nov 2004
ASUG Icon
Posts: 103



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

Hi,
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:
15.75
0
121.68
6.68
0
0
113.57
11.47
0
101.8
57.74
0
507,006.84
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
Ram
BO 5.1.3 Full client and Oracle8i
Back to top
SteveBickerton
Forum Associate
Forum Associate



Joined: 15 Aug 2002

speaker.gif*5
Posts: 544
Location: Ottawa


flag
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.

Steve

_________________
www.noscentia.com
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.0530 seconds using 17 queries. (SQL 0.0031 Parse 0.0355 Other 0.0144)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo