Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Friends,
I have a formula which is half setanalysis and half with if/else. I am struggling to covert this completely into SetAnalysis. Is it possible to convert ?
COUNT(distinct
{<
[IP] = {'High'},[RGS] = {'Active'}, [RT] = {'Selected'},
[PII] = {'A','B','C'}>}
if([data processing] = ('10,000 or greater') OR [info processing] = ('10,000 or greater'),
if((([Action Required]= 'Not Overdue' and len(Resolution)=0) OR ([Action Required]= 'Resolution Not Identified')) and
date(date#("Action Due Date" ,'MM/DD/YYYY hh:mm:ss tt') + 16,'MM/DD/YYYY hh:mm:ss tt') <= Monthend(today()),[Rel ID],
if((([Action Required]= 'Not Overdue' and len(Resolution)>0) OR [Action Required]= 'Resolution Approval Overdue') and
date(date#("Action Due Date" ,'MM/DD/YYYY hh:mm:ss tt') + 60,'MM/DD/YYYY hh:mm:ss tt') <= Monthend(today()) ,[Rel ID],
if([Action Required]= 'Not in workflow' and date(date#("Action Due Date" ,'MM/DD/YYYY hh:mm:ss tt') + 30,'MM/DD/YYYY hh:mm:ss tt') <= Monthend(today()) ,[Rel ID]
)
)
)
)
)
Could someone please help ?
Thank you.
Any help please ?