Oracle Fusion ERP Analytics

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

Change currency format

Received Response
11
Views
1
Comments

Hi, I want to change the format to Colombian pesos, in the list is available the currency, but in the column the system adds the label “COP” instead of the peso symbol “$”. How do I replace the "COP" with the “$” symbol?

Answers

  • Jamie Anderson-Oracle
    edited Nov 21, 2024 9:06PM

    Please forgive me if this is a naive workaround, but would it be possible to use the $USD/$ notation in your use case?

    I tried mocking up an example (and changing the titles of each table to show which Currency/Moneda formatting I used, and I don't think there is any way for the workbook consumer (end-user) to know that the behind-the-scenes currency format is not actually COP. However, if this is not the case, please let me know!

    Editing to add: Note that the platform is not "translating" the currency when you toggle the currency formatting options, otherwise this suggestion would obviously not work!