how to convert into set analysis expression

[vengadeshpalani]

hi all

how to convert below if condition  into set analysis expression

count(DISTINCT if(Status='Pending' and YearEndFlag='Y' and KPI_Flag='RF' and (TimeSpecial_1=0 or DueDate<Date),JobID))

[vishsaggi · Accepted solution]

May be this?

= count(DISTINCT {< Status = {'Pending'}, YearEndFlag = {'Y'}, KPI_Flag= {'RF'} >} IF(TimeSpecial_1=0 OR DueDate < Date, JobID))