Hi Gurus,

We have a column  which is of Double Datatype in Rpd.

Now we would like to have floating decimal places upto 2 decimal values (ie if its a whole number, then show it as whole number , otherwise show it with 2 decimal places)

Everything looks good in obiee but when downloaded to excel 2007, all the values have decimals at last  even when its a whole number. ( Note 164.)

How to achieve floating decimal numbers upto 2 places when downloading to excel ?

FYI- i have used  the below things already.

and

None of them helped.

My obiee version is 11.1.1.7.140715

Thanks

Ashish