All,
Is there any Add in in BusinessObjects already defined with functions to caliculate variance,If not can we write a macro to do that?
Thanks
karen (BOB member since 2003-06-18)
All,
Is there any Add in in BusinessObjects already defined with functions to caliculate variance,If not can we write a macro to do that?
Thanks
karen (BOB member since 2003-06-18)
There is a calculate variance and variance % already on the Reports tool bar. Is this what you are looking for ?
Michele Pinti (BOB member since 2002-06-17)
Thats not the one iam talking about.Iam looking for a add in which has this complex statastical functions already defined.
karen (BOB member since 2003-06-18)
You have Var(), VarP(), StdDev(), and StdDevP() as functions already. Look in the Aggregates folder on the Define Variable screen.
According to the help file variance is calculated as [quote:8ceff1c82a=“BusinessObjects 6.1 help file”]A variance is calculated by:
Calculating the average of the set of numbers
Substracting the average from each number in the set and squaring the result
Summing all these squared differences
Dividing this sum by (number of numbers in the set - 1).
[/quote]
These functions were available in version 5 as well.
Dave Rathbun (BOB member since 2002-06-06)
Thankyou
karen (BOB member since 2003-06-18)