• 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