COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Sep2013 on 17 Apr 2013 01:09:35 AM

Title: URGENT-weird format of dollars-
Post by: Sep2013 on 17 Apr 2013 01:09:35 AM
Hi frends,

i have developed a report but it shows some awfull format for numbers as attched and highlighted.
please help me to resolve this.
Title: Re: URGENT-weird format of dollars-
Post by: CognosPaul on 17 Apr 2013 01:51:08 AM
It looks like a data problem to me.

7.27595761E-12 = 0.00000000000727595761

Cognos doesn't generally render numbers with that level of detail, it rounds it using exponential notation.

Find out what the value should be and you'll be on your way to solving the problem.
Title: Re: URGENT-weird format of dollars-
Post by: Sep2013 on 17 Apr 2013 02:24:58 AM
this ones resolved by just setting the white space to "No Wrap" but, now wehn i export the output to excel some of the coulumns doesnt show up numbers.I mean blank in a column whereas there are values in html output