Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Format numbers as thousands, millions, etc. in OAS
JeffK
Rank 3 - Community Apprentice
Hi - I would like to be able to abbreviate numbers in visualizations WITHOUT applying the 'K' or 'M' labels to the number.
For example: '1,000,000' could be displayed as '1,000' or '1'
Basically the equivalent of the Excel custom formatting where:
"#,##0.0," displays 1,000.0
"#,##0.0,," displays 1.0
Currently the workaround is to create calculations on the dashboard for each measure that needs to be displayed in this manner, which of course is super inefficient.
Thanks!
Tagged:
3