I have created a turnaround time report that is broken down into 5 minute intervals and shows the number of calls made in each 5 minute increment. If a person has a certain title and they are in one of the 5 min ranges I would like them included in a separate range. I can't seem to get it to work. Checking the formula shows no errors , but it does not work. I know I am doing something wrong. can anyone give me any suggestions? This is the formula;
If {URTJ_CBPhoneResult_View.PhonedName} like [",MD", ",RN"] and
{@TAT} = "31 to 35M" then 1
else 0
If {URTJ_CBPhoneResult_View.PhonedName} like [",MD", ",RN"] and
{@TAT} = "31 to 35M" then 1
else 0