June 12, 2019 at 6:51 am
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.
June 13, 2019 at 7:10 am
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