Is there a way to specify the formatting of a field as Currency? I know I can use a format like this “-$>>,>>9.99” and get the correct display for Dollars. However, is there a better or more correct way of doing this? Especially when it comes for foreign currency?
There is a CurrSymbol field in the Currency table. Perhaps you could link to that and then create a calculated field that results in and expression similar to Currency.CurrSymbol + YourValue.Field. Which would change the currency symbol based on the currency the customer is associated with.