Formatting Number Values
The number formatting parameter begins with
\#, followed by any combination of the following parameters. Please see the examples following this table.
When Conga Composer populates a numeric value, the digit grouping symbol (the “thousands separator”) is defined according to your Locale settings (as defined in Salesforce’s
Setup | Personal Information) or according to the
Culture or
CurrencyCulture Conga Composer parameter.
Despite the cultural settings that govern the output from Conga Composer, within an appearance parameter, you
must use a comma (",") for the digit grouping symbol (for thousands) and a
period (".") as the decimal symbol.
|
PARAMETER |
DESCRIPTION |
|---|
|
0 (zero) |
Specifies the requisite numeric places to display in the result. If the result does not include a digit in that place, Word displays a 0 (zero).
Example:
{ = 4 + 5 \# 00.00 } displays "09.00". |
|
# |
Specifies the requisite numeric places to display in the result. If the result does not include a digit in that place, Word displays a space.
Example:
{ = 9 + 6 \# $### } displays "$ 15". |
|
, (digit grouping symbol) |
Separates a series of three digits.
** Note: The digit grouping symbol is always entered as a comma into the formatting code, regardless of the country’s cultural preference. Conga Composer will format the output according the cultural preference. **
Example:
{ = NetProfit \# $#,###,### } displays "$2,456,800". |
|
%, $, *, and so on |
Includes the specified character in the result.
Example:
{ = NetProfit \# "##%" } displays "33%". |
|
"positive; negative" |
Specifies different number formats for positive and negative results.
Example:
If the bookmark Sales95 is a positive value, the field { Sales95 \# "$#,##0.00;-$#,##0.00" } displays the value with regular formatting— for example, "$1,245.65". A negative value is displayed with a minus sign— for example, "-$ 345.56". |
|
Currency |
Formats the value according to the Salesforce Locale, including a currency symbol, digit grouping symbol (“thousands separator”) and two decimal places
Example:
{ MERGEFIELD OPPORTUNITY_AMOUNT \# Currency }
In Conga Composer solutions, you can override the Salesforce Locale with the “CurrencyCulture” or “Culture” parameter.
** Note: May be used with =SUM fields, in addition to merge fields ** |
|
Number |
Formats the value according to the Salesforce Locale, excluding a currency symbol, but including a digit grouping symbol (“thousands separator”) and two decimal places
Example:
{ MERGEFIELD OPPORTUNITY_AMOUNT \# Number }
In Conga Composer solutions, you can override the Salesforce Locale with the “CurrencyCulture” or “Culture” parameter.
** Note: May be used with =SUM fields, in addition to merge fields ** |
|
Percent |
Formats the value according to the Salesforce Locale, by multiplying the value by 100 and including a digit grouping symbol (“thousands separator”), two decimal places and a percent sign.
Example:
{ MERGEFIELD OPPORTUNITY_PROBABILITY \# Percent }
In Conga Composer solutions, you can override the Salesforce Locale with the “CurrencyCulture” or “Culture” parameter.
** Note: Not for use with =SUM fields ** |
Example 1:Here are several common examples of the number appearance parameter. Let’s say the field we’re formatting is OPPORTUNITY_AMOUNT and that it contains 5280.25 and the Salesforce Locale is “English (United States)”.
|
EXAMPLE |
OUTPUT |
|
{ MERGEFIELD OPPORTUNITY_AMOUNT \# #,##0 } |
5,280 |
|
{ MERGEFIELD OPPORTUNITY_AMOUNT \# $#,##0 } |
$5,280 |
|
{ MERGEFIELD OPPORTUNITY_AMOUNT \# #,##0.00 } |
5,280.25 |
|
{ MERGEFIELD OPPORTUNITY_AMOUNT \# Currency } |
$5,280.25 |
|
{ MERGEFIELD OPPORTUNITY_AMOUNT \# Number } |
5,280.25 |
Example 2:Let’s change the scenario a bit. Let’s assume we’re formatting the same field value as above, however, the Salesforce Locale is “German (Germany)”.
|
EXAMPLE |
OUTPUT |
|
{ MERGEFIELD OPPORTUNITY_AMOUNT \# #,##0 } |
5.280 |
|
{ MERGEFIELD OPPORTUNITY_AMOUNT \# #,##0 € } |
5.280 € |
|
{ MERGEFIELD OPPORTUNITY_AMOUNT \# #,##0.00 } |
5.280,25 |
|
{ MERGEFIELD OPPORTUNITY_AMOUNT \# Currency } |
5.280,25 € |
|
{ MERGEFIELD OPPORTUNITY_AMOUNT \# Number } |
5.280,25 |
About Us | Privacy Statement | Terms of Use | Read Our Reviews | Knowledge Base Home