Set Currency Symbols for Visualizations

You can set measure values in a visualization to display an appropriate currency symbol.

Oracle Analytics offers a list of currencies to choose from, or you can configure a measure to use a custom currency to display the symbol associated with a currency. For example, if you set a canvas filter to display a European Ledger, then the Euro symbol is displayed for each measure value that's associated with the custom currency property. The workbook data must contain a currency code column, for example, a Ledger Currency column. The currency code column enables the display of an appropriate currency symbol for the measure column, for example, a Profit column.
  1. On your home page, hover over a workbook, click Actions, and select Open.
  2. Select a visualization.
  3. Click Properties, then click Values Values Properties tab.
  4. Expand the measure that you want to format.
  5. Under Number Formats, in the row for the output you want to configure, click Auto and select Currency.
  6. In the Currency field, click the currently displayed value and select either Custom or the currency you want to display.
  7. If you selected Custom, click the Select a Currency Column field, and add the column that determines the currency code.
  8. Click Save.
    Tip: If you're your currency values are prefixed with country code and currency symbol in a Chrome browser, use the Languages settings in Chrome to set the Language value, which affects the format displayed in workbooks. For example, set the Language to "English (United States)" to prefix currency values with $ instead of US$.