Export to Excel has Decimal point always in Number format even in case of whole numbers — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Export to Excel has Decimal point always in Number format even in case of whole numbers

Received Response
51
Views
3
Comments
Ashish Gupta
Ashish Gupta Rank 1 - Community Starter

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.)

pastedImage_0.png

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

FYI- i have used  the below things already.

pastedImage_1.png

and

pastedImage_2.png

None of them helped.

My obiee version is 11.1.1.7.140715

Thanks

Ashish

Answers