Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
May be this?
= count(DISTINCT {< Status = {'Pending'}, YearEndFlag = {'Y'}, KPI_Flag= {'RF'} >} IF(TimeSpecial_1=0 OR DueDate < Date, JobID))
May be this?
= count(DISTINCT {< Status = {'Pending'}, YearEndFlag = {'Y'}, KPI_Flag= {'RF'} >} IF(TimeSpecial_1=0 OR DueDate < Date, JobID))