Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how could I create a set analysis with the below if statement.
Any input would help
COUNT(DISTINCT IF([Open_Date]<=end_date AND [Status]<>"V" AND [Status]<>"Void", IF([Closed_Date]>end_date OR IsNull([Closed_Date]), [Number], NULL), NULL))
thanks
I would do this in the load script. The part where you are using the Isnull() function is especially problematic because the whole concept of Set Analysis is centered around replicating selections and it is not possible to select nulls, by definition they are nothing and therefore not selectable.
I also assume the condition your are using is intended to qualify an association between two tables, when you do that you are going to need to be carefull to not create a cartesian product.
I would do this in the load script. The part where you are using the Isnull() function is especially problematic because the whole concept of Set Analysis is centered around replicating selections and it is not possible to select nulls, by definition they are nothing and therefore not selectable.
I also assume the condition your are using is intended to qualify an association between two tables, when you do that you are going to need to be carefull to not create a cartesian product.