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





      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.