Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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%'))
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%'))