SOLVED

Format as Currency

Super Contributor

hello experts,

 

I need to format [Amount] as either $, €, or kr

 

I have a field [Currency] that is text and displays one of 3 currencies: USD, EUR or DKK

How can I display the currency symbol in my [Amount] field based on the text value in [Currency]? 

$12,345.45

€12,345.45

kr12,345.45

thank you 

2 Replies
best response confirmed by Tony2021 (Super Contributor)
Solution
your system only assign 1 currency symbol based on your regional setting.
for multiple currency, you need an additional short text field to put those
different currency symbol.
I just covered this in one of my videos. See: https://599cd.com/CurrencySymbols