Getting "The ) is missing" error in formula

[gshadz37]

I am using Crystal reports 8 and am getting a "The ) is missing" error in this formula -

IF ({ApplicationDetail_BE.CALLDETAIL.DEST_GROUP} NOT IN([150,151,155])) AND
{ApplicationDetail_BE.CALLDETAIL.DISPOSITION} = 5
THEN 1 ELSE 0

Does anyone see what my mistake might be?

Thanks!

 

[SkipVought]

IF ({ApplicationDetail_BE.CALLDETAIL.DEST_GROUP} NOT IN([150,151,155]) AND
{ApplicationDetail_BE.CALLDETAIL.DISPOSITION} = 5
THEN 1 ELSE 0)

 

[AndyMc]

You've got the NOT in the wrong spot:

IF not({ApplicationDetail_BE.CALLDETAIL.DEST_GROUP} IN [150,151,155]) AND
{ApplicationDetail_BE.CALLDETAIL.DISPOSITION} = 5
THEN 1 ELSE 0