Filtering out on multiple measures

[zgeorge]

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'.

[adam_mc]

Something like...

[Measure1] is not null AND
[Measure2] is not null AND
[Measure3] is not null