Simple detail filter Contains/or

[icarder]

Hello,

I'm struggling with something that I'm sure should be really simple.  All I'm trying to do is filter on a data item(Personnel Employee Type Code) if it has an A or a B.  I keep getting various parsing errors.  Even using the select multiple values button in the detail filter expression, I still get the errors while trying to validate.  Here's what I tried:

[Personnel Employee Type Code] = ('A', 'B')

Any help would be greatly appreciated. 

[charon]

Hi icarder,

you might wanne try
[Personnel Employee Type Code] in  ('A', 'B')

or
[Personnel Employee Type Code] in ('A'; 'B') (in europe there is used a semicolon.

GL and cheerz :)

[icarder]

Charon,

That worked perfectly.  Thanks for helping a cognos simpleton!

[charon]

You are welcome sir  :D