count

[srinu_anu2007]

Hi,

below is the my requirement, iam unable to find

count([business layer]. [e].[z]) for distinct e's dat have the same [b.layer]..

• 
  
  Expla:Having 2diffrent tables and 2 columns are numbers
  e and b ----- Tables
  Z and x ----- columns those are numbers
  
  these are my requirement can any one suggest on the same.
  
  Thanks,
  Anu

[tjohnson3050]

count(e for x)

The extension FOR allows you to control the aggregation grain level from inside the expression.  Read the syntax tips for any aggregation function and you can see the FOR extension.  Learning the FOR extension inside and out will greatly increase your ability to effectively report in Cognos. 

[srinu_anu2007]

Thanks! for your valuable information.