Friday, February 25, 2011

How to count only certain data in Cognos Report Studio?

Sometimes a count needs to be made on data that needs to meet certain requirements.
There are several ways to acomplish this.

Example:
COUNT ( IF ( [FrameworkField] <= 2700 ) THEN (1) ELSE (0) )
or
Example:
CASE WHEN ( [FrameworkField] <= 2700 ) THEN (1) ELSE (0) END

0 reacties:

Post a Comment