Print Page - Incorrect rounding of decimal value

Title: Incorrect rounding of decimal value
Post by: Aravinth on 31 Oct 2007 11:25:35 AM

Hi All,

I need to remove the decimal values without rouning the value.

current value =78.90
expected value=78

Above filed is a summary field. Any thoughts if pattern in data formating can be used?

Title: Re: Incorrect rounding of decimal value
Post by: MFGF on 31 Oct 2007 12:01:10 PM

Hi,

Using a floor() function should give you the correct results.

Regards,

MF.

Title: Re: Incorrect rounding of decimal value
Post by: Suraj on 31 Oct 2007 12:02:34 PM

MFGF answered what I was typing... :)
floor([data item]

Title: Re: Incorrect rounding of decimal value
Post by: COGNOiSe administrator on 31 Oct 2007 01:35:46 PM

Hey, he is gooood ... ;D

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Aravinth on 31 Oct 2007 11:25:35 AM