Formatting Numeric Values in PDF Templates
The following numeric formatting codes are used in conjunction with the “Numeric” parameter.
When Conga Composer populates a numeric value, the digit grouping symbol (the “thousands separator”) is defined according to your Locale settings (as defined in) 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).
|
|
# | 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.
|
|
, (digit grouping symbol) | Separates a series of three digits. 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.
|
|
%, $, *, and so on |
Includes the specified character in the result. |
|
"positive; negative" |
Specifies different number formats for positive and negative results. |
For example:
- Merge Field: Master.OPPORTUNITY_DISCOUNT_PERCENT has a value of 33
- Master.OPPORTUNITY_DISCOUNT_PERCENT(Numeric 0##%) will output as "3300%"
- Merge.fieldMaster.OPPORTUNITY_DISCOUNT_PERCENT has a value of 0.33
- Master.OPPORTUNITY_DISCOUNT_PERCENT(Numeric 0##%) will output as "33%"
To work around this, we recommend creating a formula field to process the value of the original field into a proper decimal format.
Here are several common examples of the number appearance parameter. Let’s say the field we are formatting is OPPORTUNITY_AMOUNT and that it contains 5280.25 and the Salesforce Locale is “English (United States)”.
|
Example |
Output |
|---|---|
|
|
5,280 |
|
|
$5,280 |
|
|
$5,280.25 |
|
|
$5,280.25 |
|
The data must be entered without additional formatting like spaces or dashes (for example: 6517331110) in the View Data workbook. |
(651) 733-1110 |
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 |
|---|---|
|
|
|
Master.OPPORTUNITY_AMOUNT(Numeric "#,##0 €")
The formatting code is enclosed in straight quotes because it contains spaces. |
|
|
|
|
|
|
|
