topic If statement to Set Analysis in App Development

If statement to Set Analysis

Luben — Wed, 10 Nov 2021 15:23:48 GMT

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

Re: If statement to Set Analysis

stevejoyce — Wed, 10 Nov 2021 15:55:20 GMT

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

Re: If statement to Set Analysis

Luben — Wed, 10 Nov 2021 18:53:03 GMT

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

Thanks

Re: If statement to Set Analysis

stevejoyce — Wed, 10 Nov 2021 18:59:28 GMT

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