COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: jasp on 18 Feb 2010 08:34:13 AM

Title: Count Formula
Post by: jasp on 18 Feb 2010 08:34:13 AM
Hi All, new to Rs, so any help would be appreciated.

I need to count the number of members withinin a  expression.

So if i have a formula say children ([2010]), it should give me all 12 months, what i would like to know is how many months have been counted.

I tried Count ([data item]) but it did not work , any help.
Title: Re: Count Formula
Post by: CognosPaul on 19 Feb 2010 03:50:25 AM
try count(1 within set [data item])
It will create a 1 for each member in the data item set and count that. total(1 within set [data item]) will work just as well.