Home Forums Data Warehousing Analysis Services MDX trouble in a calculated member RE: MDX trouble in a calculated member
Mackers
SSCrazy
Points: 2935
More actions
January 20, 2013 at 10:09 am
#1579032
Think I've got the iif statement the wrong way around
IIF(ISEMPTY([Measures].[Sales Amount] )
,NULL
,SUM ({ [Company].[All Company].[COMET]},[Measures].[Sales Amount]) )
,NON_EMPTY_BEHAVIOR = {[Measures].[Sales Amount]}
Apologies
Mack