Filter to See Both Nulls and 4 Values

[Cognos_Jan2017]

We have a Field [EIC] which can have may different entries, or be Null.

Setting its Filter by clicking its Column in a List as ...
1 - [EIC] includes Null
2 - [EIC] includes ('A', 'B', 'C', 'D')  <--- 'A', 'B', 'C', 'D' used for simple examples.

... results in seeing ONLY Nulls in [EIC].

Why might this occur?  Is there a reliable method to set a Filter to "include" Nulls and selected Values?

TIA - Bob

[MFGF]

We have a Field [EIC] which can have may different entries, or be Null.

Setting its Filter by clicking its Column in a List as ...
1 - [EIC] includes Null
2 - [EIC] includes ('A', 'B', 'C', 'D')  <--- 'A', 'B', 'C', 'D' used for simple examples.

... results in seeing ONLY Nulls in [EIC].

Why might this occur?  Is there a reliable method to set a Filter to "include" Nulls and selected Values?

TIA - Bob

How about

[EIC] is null OR [EIC] in ('A','B','C','D')

Cheers!

MF.

[Cognos_Jan2017]

Yes, THANK you.

Pretty simple statement, and I need to learn more of those.