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

Author Topic: Decimal values in text promp  (Read 6063 times)

Offline rajurokz

  • Full Member
  • ***
  • Join Date: Mar 2016
  • Posts: 11
  • Forum Citizenship: +0/-0
Decimal values in text promp
« 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

Offline CognosPaul

  • Global Moderator
  • Statesman
  • *****
  • Join Date: Jan 2009
  • Posts: 1,912
  • Forum Citizenship: +268/-1
    • Paul's Cognos Blog
Re: Decimal values in text promp
« Reply #1 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.

Offline rajurokz

  • Full Member
  • ***
  • Join Date: Mar 2016
  • Posts: 11
  • Forum Citizenship: +0/-0
Re: Decimal values in text promp
« Reply #2 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