Add a Not Null expression in MDX

  • Hello,

    I have a KPI with this expression:

    IIF(([Measures].[Fact Service Request Count],[Fact Service Request].[Be In KPIS].&[1],[Fact Service Request].[Applicant].&[1],[Fact Service Request].[Valid Humanity].&[1], [Subscriber].[KInd].&[1],[Fact Service Request].[Be Control].&[1],[Fact Service Request].[Control Result].&[1])=Null,0,([Measures].[Fact Service Request Count],[Fact Service Request].[Be In KPIS].&[1],[Fact Service Request].[Applicant].&[1],[Fact Service Request].[Valid Humanity].&[1], [Subscriber].[KInd].&[1],[Fact Service Request].[Be Control].&[1],[Fact Service Request].[Control Result].&[1]))

    I wanna add this condition :"[Fact Service Request].[Payment Date] is not null".

    How could I write it?

    Thanks in advance.

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply