Hi all,

Just looking for some wisdom and help.

I currently have a report which has a field that has this formula:

if((({GF_CALLDETAIL.CALL_TYPE})=3 or{GF_CALLDETAIL.CALL_TYPE}= 4) and (isnull({GF_CALLDETAIL.DIAL_DIGIT}) 
or 
length({GF_CALLDETAIL.DIAL_DIGIT})<3))
then 1
else 0

This works fine, I didn't write it, what its saying is if call type is 3 or 4 and dial digits is null or below 3 then count 1 otherwise don't

What I'm trying to do is this:

if((({GF_CALLDETAIL.CALL_TYPE})=3 or{GF_CALLDETAIL.CALL_TYPE}= 4) and (isnull({GF_CALLDETAIL.DIAL_DIGIT}) 
or 
length({GF_CALLDETAIL.DIAL_DIGIT})<3)xor({GF_CALLDETAIL.DIAL_DIGIT})=45 xor{GF_CALLDETAIL.DIAL_DIGIT}=49 xor{GF_CALLDETAIL.DIAL_DIGIT}=4)
then 1
else 0

Which I hope is saying the same apart from if dialed digits length is under 3 but dialed is not 45 49 4.