If condition within Set Analysis expression

[Sharad02]

Can you please help to me to write the below if condition inside the set analysis please

I wanted convert those if condition into set analysis

=if(Indicators_RPA = 'Success rate'
,num(
Alt(count(DISTINCT{<Status = {'3'}
,StartProcessing = {"<=$(=Date(vRPAToDate, 'D.M.YYYY 23:59:59'))"}
,EndProcessing = {">=$(=Date(vRPAToDate - 90, 'D.M.YYYY 0:00:00'))"}>}
if(len(Stream_RPA)>0,
Id))
/
count(DISTINCT{<Status =
,StartProcessing = {"<=$(=Date(vRPAToDate, 'D.M.YYYY 23:59:59'))"}
,EndProcessing = {">=$(=Date(vRPAToDate - 90, 'D.M.YYYY 0:00:00'))"}>}
if(len(Stream_RPA)>0,
Id))
, 0)
,'0.00%'))

I appreciate if you could help me to resolve the issue.

[vinieme12 · Accepted solution]

as below

 =if(Indicators_RPA = 'Success rate'
,num(
Alt(

count(DISTINCT{<Status = {'3'}
,StartProcessing = {"<=$(=Date(vRPAToDate, 'D.M.YYYY 23:59:59'))"}
,EndProcessing = {">=$(=Date(vRPAToDate - 90, 'D.M.YYYY 0:00:00'))"}

,Id={"=len(Stream_RPA)>0"}

>}
Id)
/
count(DISTINCT{<Status =
,StartProcessing = {"<=$(=Date(vRPAToDate, 'D.M.YYYY 23:59:59'))"}
,EndProcessing = {">=$(=Date(vRPAToDate - 90, 'D.M.YYYY 0:00:00'))"}>}

,Id={"=len(Stream_RPA)>0"}

>}
Id) , 0) 

,'0.00%'))