Formatting Currency Values on a Dynamic, Record-by-Record Basis
Format currency values based on a field on a record. Let’s say we’re creating a quote from an Opportunity and we’d like format currency values based on a field in the Opportunity. Here’s how:
-
Create a picklist field on the Opportunity to contain
the culture choices.
Let’s call the field Culture. In this example, let’s use the following choices:
These settings would result in output such as:
|
|
|
|
|
|
Disable Wrap Text in cells that use Currency formatting to keep the value and the symbol on the same line: .
Also view: Dynamic template selection using Salesforce formula field
