Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: andershedin on 21 Feb 2023 07:55:52 AM

Title: Create a data item display the same total value in each row
Post by: andershedin on 21 Feb 2023 07:55:52 AM
Hi guys, im trying to create a data item that will display a count distinct [Account Numbers] for the table, and have it repeated on each row with the same value without incrementing.

I tried Count (Distinct [accountnumber]) but it only displays '1' for each row. Thanks for any help
Title: Re: Create a data item display the same total value in each row
Post by: MFGF on 21 Feb 2023 08:27:01 AM
Quote from: andershedin on 21 Feb 2023 07:55:52 AM
Hi guys, im trying to create a data item that will display a count distinct [Account Numbers] for the table, and have it repeated on each row with the same value without incrementing.

I tried Count (Distinct [accountnumber]) but it only displays '1' for each row. Thanks for any help

Have you tried count(distinct [accountnumber] for report)

Cheers!

MF.
Text only | Text with Images