If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Count Formula

Started by jasp, 18 Feb 2010 08:34:13 AM

Previous topic - Next topic

jasp

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.

CognosPaul

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.