Count Issue

[priya@90]

Hello,

I am facing an issue with count. i have an data item called emp_sk and iam doing count(emp_sk) and it should come total but report is giving individula records and report filters are [BU]='GPSD' etc

GPSD is having 11 records but in cognos its giving individual records as per attachment and also DB2 is giving correct result 11 records.

Please help to get total records as 11 not individual and i tried to apply grouping also but no luck

Thanks,
Priya

[MFGF]

Hello,

I am facing an issue with count. i have an data item called emp_sk and iam doing count(emp_sk) and it should come total but report is giving individula records and report filters are [BU]='GPSD' etc

GPSD is having 11 records but in cognos its giving individual records as per attachment and also DB2 is giving correct result 11 records.

Please help to get total records as 11 not individual and i tried to apply grouping also but no luck

Thanks,
Priya

How about count([emp_sk] for [GPSD])

MF.

[priya@90]

Your Awesome MFGF gee and it's working perfectly . Thanks a lot i didn't try this with my less experienced.

Thanks,
Priya

[priya@90]

count([emp_sk] for [BU]) what does this mean exactly? what it will do? Can some one explain please.

Thanks,

[MFGF]

count([emp_sk] for [BU]) what does this mean exactly? what it will do? Can some one explain please.

Thanks,

It will return a count of the number of emp_sk values for each BU value.

MF.