Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thanks a lot.