If condition within Set Analysis expression

Sharad02 — Mon, 31 Oct 2022 15:09:14 GMT

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.

Re: If condition within Set Analysis expression

vinieme12 — Tue, 01 Nov 2022 03:00:56 GMT

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%'))

topic If condition within Set Analysis expression in App Development

If condition within Set Analysis expression

Re: If condition within Set Analysis expression