6 Replies Latest reply: Sep 27, 2012 10:53 AM by grahhal89 RSS

    How do I select one field and exclude another?

      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....