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] ) ) ) ) )
