Currency Symbol Display

[EGamage]

We have created a formula and presentation variable that allows the user to make a selection on what dollar amount they want to see and in what currency. What we would like to be able to do is show the USD with a dollar $ sign. The ledger and local would not include the dollar sound and we would the currency code as well in a separate column. The formula works just curious if anyone has thoughts on adding the $ sign for USD only.

Formula:

IF(

    $CURRENCY_DISPLAY_CHOICE = "LOCAL",

    Global_Subscriber_Rolling_Base.Global_SRB_Contract_Activity.LOCAL_CURRENCY_AMOUNT,

    IF(

        $CURRENCY_DISPLAY_CHOICE = "LEDGER",

        Global_Subscriber_Rolling_Base.Global_SRB_Contract_Activity.LEDGER_CURRENCY_AMOUNT,

        IF(

            $CURRENCY_DISPLAY_CHOICE = "USD",

            Global_Subscriber_Rolling_Base.Global_SRB_Contract_Activity.USD_AMOUNT,

            0

        )

    )

)

[DustinB]

Hi @EGamage In the past, we've done this by casting the number as a string and using conditional logic to concatenate the dollar sign. The downside is the metric is now a string and you lose functionality (e.g. alpha instead of numerical sorting).

[EGamage]

@DustinB Thank You. We had explored that option, and the loss of functionality has a greater impact than not having the dollar sign. Thank you for your response.

[LayeredDelay]

@EGamage Can you share a little more on the business use case here. In my past days at Oracle for Financials we would show local currency and then functional currency in two different columns, we wouldn't combine them as that causes a lot of confusion, especially when looking at radically different numbers. We would show the currency in the header such as "GL Amount ($)" - would that work? I do agree that for local currency it would be nice to have the ability to pick a currency prefix based on a field such as currency code. These are the features we are looking to support as part of our roadmap items around Financial use cases. More to come soon. In the meantime if you can share more that would be awesome.