COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: et21 on 29 Sep 2022 06:39:16 PM

Title: Exclude Decimal Out from Report
Post by: et21 on 29 Sep 2022 06:39:16 PM
Hi all I have a question about decimal number. I have 5 value and 2 of them are decimal and i dont want it to display.

Ex:
10
11.2
15.5
5
3
I want to show only 10 5 and 3 in report. Any Idea how to do that?
TIA
Title: Re: Exclude Decimal Out from Report
Post by: dougp on 29 Sep 2022 07:14:01 PM
You want to add a filter so only rows with integers are included in the output?

mod([my data item], 1) = 0