If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Exclude Decimal Out from Report

Started by et21, 29 Sep 2022 06:39:16 PM

Previous topic - Next topic

et21

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

dougp

You want to add a filter so only rows with integers are included in the output?

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