7 Replies Latest reply: Feb 12, 2018 5:58 PM by Ric Morgan RSS

    Count if query

    Ric Morgan

      Hi Guys,

       

      I'm currently creating a KPI to show a total number of records that have a Creation Date and a Start Date

       

      i.e. count(NetWorkDays("Creation Date", "Start Date"))

       

      However, I only want to include records where there is no value in the cancelled column (i.e. the appointment has not been cancelled)

      I also want to exclude records that are follow up appointments , these have a "Y" in the follow ups column....

       

      So I tried this

       

      count(

      {<[Cancelled]={"NULL"}>}

      {<[Followup]-={"Y"}>}

      NetWorkDays("Creation Date", "Start Date"))

       

      But this does not work. There is also a possibility that an appointment could be Cancelled AND be a follow up.

       

      Any help here would be much appreciated.