Crystal Report Formula

[jj72uk]

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 dialled is not 45, 49, 4.

This doesn't work as it says there is a problem with the formula when I try to save it.

Any help?

 

[kevlray]

instead of xoring do a AND NOT(({GF_CALLDETAIL.DIAL_DIGIT})=45 AND NOT(({GF_CALLDETAIL.DIAL_DIGIT})=49 AND NOT(({GF_CALLDETAIL.DIAL_DIGIT})=4