Posted: 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.
Thanks in advance
BO 5.1.3 Full client and Oracle8i
Posted: 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