This content has been marked as final. Show 7 replies
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.