I have an MDX which returns me certain columns like "Sales Value", "Sales Units" etc. Now I need to find the average price which will be Sales Value/ Sales Units. But when I write this in MDX then sometimes I either get empty space or any gibberish value.
I want to know what format type I need to select to fetch the actual value. My value would come something like, 0.00231.
The MDX that I have written is,
[Measures].[Current Year Sales Value] as ' ( [Measures].[SalesValue], [PERIOD].[All
[Measures].[Previous Year Sales Value]
View Complete Post