walter.anto (4/4/2013)
Hello,I have a problem to calculate the variance.
Here is the code I use:
Axis([Measures]).item(0)-Axis([Measures]).item(1)
Dynamically, the calculated measure makes the subtraction between the first measure and the second measure.
On the other hand, when that I add dimensions, an error displays.
Help !
Thank you very much.
The axis function seems like overkill for the requirement. How about :
WITH Member [Measures].[ItemVariance] as
(
[Measures].[Name of First Measure] - [Measures].[Name of Second Measure]
)
I wonder about it being called variance though. Variance is a statistical value related to standard deviation (standard deviation squared).
Subtracting one from the other would be the "difference".