Count not working properly in Report Studio

[nsaha]

Hi Everyone,

Yesterday i was using 'count' for some data members in a list of Cognos 8.3.Suppose I want to find no of policies in any year suppose for 2009.But I think the count was not giving proper result.All the results except the data members having 'count' is coming fine. Is there any other way to find the count of data member in Report studio?Is the result not coming for incorrect joining???Please provide a solution.It will b a great help for me.Thanks in advance.

[saumil287]

Hi
I think the data member for which u want count,the aggregate property must be set to count
or distinct count.
Or u can use funct eg distinct count([data member])

try using it.