Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Export to Excel has Decimal point always in Number format even in case of whole numbers

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
Answers
-
Any inputs from anyone ?
0 -
anyone?
0 -
Just in case check these
Doc IDs 1672130.1 and 1364974.1
0