Need help with a formula

[Rosy1]

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

 

[lbass]

Try:

If {URTJ_CBPhoneResult_View.PhonedName} like ["*,MD", "*,RN"] and
{@TAT} = "31 to 35M" then 1
else 0

Also, if you have a group on {@Tat}, then you don't need to include that clause in your formula. If there is variation in the way the degree is added, e.g., like ", MD", then you need to add those options to the formula, also.

-LB