April 4, 2013 at 3:56 am
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.
April 4, 2013 at 10:30 pm
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".
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply