COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Upgrading to Cognos 10 => Topic started by: rajurokz on 27 Sep 2017 04:14:21 pm

Title: Decimal values in text promp
Post by: rajurokz on 27 Sep 2017 04:14:21 pm
Hi,

I have a strange situation where parameter is not passing decimal values. i'm trying to filter the report based on check amount. When prompted for 8.77, the report shows no data. But there is a record for this value and its same with all the decimal values. What i understand is parameter is not passing the exact amount with decimal value, and there is no problem with the round figures. please help me.

Thanks,
Rajurok
Title: Re: Decimal values in text promp
Post by: CognosPaul on 27 Sep 2017 10:06:25 pm
If you modify the filter to [Data Item] = 8.77 does it work? What is the data type of the field? Some databases will automatically round floats for display, but filtering won't necessarily work the way you expect.
Title: Re: Decimal values in text promp
Post by: rajurokz on 28 Sep 2017 10:20:19 am
[Data Item] = 8.77 works perfectly fine, but there's a problem with the parameter. The datatype is Int and the db is DB2.


thanks,
Rajurokz