13 Replies Latest reply: Dec 10, 2013 10:14 AM by Shoaib Rafiq RSS

    Count with multiple Conditions

      Hi,

       

      I want to calculate how many applications are sanctioned. The criteria is: Sanctioned = Sanctioned-not Booked+Booking Started+Lender Decision for the following data. Can I just use <Case expression> to get the above or would have to must use Appl_ID

       

      APPL_ID<CASE  expression>
      19681349ENTERED
      19737483DECLINED
      11089833Booking Started
      11829485BOOKED
      13145469DECLINED
      10510490DECLINED
      15079449BOOKED
      16357070BOOKED
      17715414Lender Decision
      19097166BOOKED
      12671357DECLINED
      12973150DECLINED
      13417909DECLINED
      15294770BOOKED
      17432881SYSTEM DECISION
      13579447BOOKED
      19212301Sanctioned-Not Booked
      10369751REFERRAL EVENT
      15752122BOOKED
      14255114DECLINED
      10240186DECLINED
      19214097Cancelled
      15874564BOOKED
      12260756DECLINED
      11978952BOOKED
      15505655Cancelled
      11368921BOOKED
      11087854Lender Decision
      13137807BOOKED
      16159271Cancelled
      16510501BOOKED
      10393592BOOKED
      10007616BOOKED
      11916336BOOKED
      18191506BOOKED
      14763573BOOKED
      10256936REFERRAL EVENT
      18988955BOOKED
      13848021DECLINED
      17872078BOOKED
      16139673BOOKED
      16067788Sanctioned-Not Booked