Hello Cognos Masters,
How can I filter out measures based on multiple values. What I'd like to do is filter out a row in a list IF all measures are either null or 0(Against a relational model). So something like this ...
([Measure1] AND [Measure2] AND [Measure3]) <> null
This logic does not work in a detail filter, it errors out and doesn't like the 'AND'.
Something like...
[Measure1] is not null AND
[Measure2] is not null AND
[Measure3] is not null