April 12, 2010 at 1:07 pm
Hello
I am trying to create a calculated member that uses the positive (Absolute) value of the measures shown in the cube.
The dimension is [Version] which contains several members: [1.Budget], [2.Actual], [3.Forecast_1], [4.Forecast_2], [5.Forecast_3]
The calculated member will show the deviation, for instance 2.Actual vs 1.Budget, so I placed the following MDX expresion to do so:
([SalesDB].[Version].&[1.Actual]/+[SalesDB].[Version].&[2.Budget]-1)
I was expecting that the "+" operator will give the positive (absolute) vallue of the measures placed on the cube, but it did't.
Do you think I am doing something wrong, advice is appreciated
--
Douglas
April 12, 2010 at 2:37 pm
You could try using the ABS() function. Usually you apply this to measures versus dimensional values though.
Steve.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply