If statement to Set Analysis

[Luben]

hello all i help looking at this if statement, I am trying to convert it to Set analysis.

COUNT(
distinct aggr (
IF (
(
[Open_Date]<=Vend_date
and Status<>'V'
AND Status<>'Void'
)
AND
(
[Closed_Date]>Vend_date
OR IsNull([Closed_Date])
)
,[C_Number]
)
,[C_Number]

Thanks for the feed backs

[stevejoyce]

Try this:

count(distinct {<[C_Number] = {"=[Open_Date]<=Vend_date"}, Status -= {'V', 'Void'}> * <[C_Number] = {"=[Closed_Date]>Vend_date OR IsNull([Closed_Date])"]>} [C_Number])

[Luben]

Thanks for your response when I added the above I get error in the expression builder and the KPI is blank.

Thanks

[stevejoyce · Accepted solution]

Sorry i was hoping you could cleanup any syntax issues as i dont have these fields.  i took a manual look through, try this, there was an extra ] in what i posted.:

count(distinct {<[C_Number] = {"=[Open_Date]<=[Vend_date]"}, [Status] -= {'V', 'Void'}> * <[C_Number] = {"=[Closed_Date]>[Vend_date] OR IsNull([Closed_Date])">} [C_Number])