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
Quote from: Cognos_Jan2017 on 06 Feb 2018 12:21:27 PM
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.
Yes, THANK you.
Pretty simple statement, and I need to learn more of those.