Set Analysis?

[prajapatiamar38]

Hi,
How can we write following expression in set analysis:

=Count(distinct if((CR1_Jobcardclosed_Date-CR1_Jobcard_Date))<=2,CR1_Total_Unscheduled_Jc))

Plz Help......

Thanks

[tresesco · Accepted solution]

Sorry, I did not notice carefully, there are two fields (and you are actually trying to calculated the difference). Try:

=Count({<CR1_Total_Unscheduled_Jc={"=CR1_Jobcardclosed_Date-CR1_Jobcard_Date<=2"}>} distinct CR1_Total_Unscheduled_Jc)

[prajapatiamar38]

This seems to be which I am looking for.

It works fine now.

Thank you for your help.