Set analysis problem

[#1]

Hi Everyone,

I am trying to count the number of projects completed before deadline using set analysis.

I am using the following code:

count ( { < Completion_Date = { " <= Deadline_Date " } > } ProjectID )

I am not getting the right result. Please help!

Regards

Arun

[lironbaram · Accepted solution]

hei

in your case use

count (if(Completion_Date <= Deadline_Date , ProjectID ))

set analysis wont work as it get only one value in your case is null

set analysis is like making  a selection so after the <= i try to calculate a value

but as there more then one value of Deadline Date it will get null

[#3]

Thanks a lot.