nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

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

Ashish Gupta

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

Find more posts tagged with

Accepted answers

All comments

Ashish Gupta

Any inputs from anyone ?

Ashish453

anyone?

SriniVEERAVALLI

Just in case check these

Doc IDs 1672130.1 and 1364974.1