COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: cielo on 04 Dec 2019 04:36:28 PM

Title: Sequence ID
Post by: cielo on 04 Dec 2019 04:36:28 PM
Deal all:

How can I generate a sequence ID in Cognos report list object


Have used: running-count(coalesce([USERID],0))
No. PROD DescripciĆ³n USERID
1
2 value1    value 2    value 3


Issue is when there are null values it is generating an empty row, How could I avoid first row

Thank you in advance