How do I select one field and exclude another?

[#1]

I have one field that says 'Referral Date' which has a list of dates when people were referred to our prorgam. Those that were eligible for our program are placed and we have a field called 'Placed Date.' I want to write an expression to count the number of people that were referred (i.e. count(Referred_Date)) and exclude the number of placed date (that would give me the number of people that were Closed (i.e. referred to our program but not placed).

Any ideas? Really have no idea on this one....

[swuehl · Accepted solution]

Maybe just

=count(Referred_Date)-count(Placed_Date)

?

[#3]

I feel like an idiot haha that actaully would give me what I want.

Thanks

[#4]

  Try this

=

Count(RefDate)-Count(PlaceDate)

[#5]

Yup! Thanks

[qliksus]

How is your Referred Date and Placed Date value is stored for a Person

count(if ( isnull(placed date) ,    reffrreddate) )

if the data is stored like if a person is reffred and not placed then the placed date will be null so the above expressio  will work if the data is stored differently let  me know so that we can change the logic   

[#7]

That is exactly what I was trying to do. Worked perfectly. The isnull function is what I was searching for.

::Two thumbs up::