Print Page - Find values on all lines

Title: Find values on all lines
Post by: cring on 23 Feb 2015 02:35:32 PM

I have an internal control number that can have multiple lines for each. I am trying to find those internal control numbers where ALL lines equal the same value. Any help is appreciated!

Example:

Internal Control Number Line # Value
11111111111111 1 xyz
11111111111111 2 xyz

Title: Re: Find values on all lines
Post by: BigChris on 02 Mar 2015 06:15:05 AM

You might be able to do this with a filter, something along the lines of:

count([Line #] for [Internal Control Number],[Value]) = count([Line #] for [Internal Control Number])

Have an experiment and see what that throws up...

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: cring on 23 Feb 2015 02:35:32 PM