Skip to main content
Conga Support

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 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).

Master.OPPORTUNITY_AMOUNT(Numeric 0.00) displays "5280.25".

#

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.

Master.OPPORTUNITY_AMOUNT(Numeric ###0) displays "5280 ".

, (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.

Master.OPPORTUNITY_AMOUNT(Numeric #,##0.00) displays "5,280.25".

%, $, *, and so on

Includes the specified character in the result.

"positive; negative"

Specifies different number formats for positive and negative results.

 

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

Master.OPPORTUNITY_AMOUNT(Numeric #,##0)

5,280

Master.OPPORTUNITY_AMOUNT(Numeric $#,##0)

$5,280

Master.OPPORTUNITY_AMOUNT(Numeric $#,##0.00)

$5,280.25

Master.OPPORTUNITY_AMOUNT(Currency)

$5,280.25

 

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)

5.280

Master.OPPORTUNITY_AMOUNT(Numeric "#,##0 €")

Note: The formatting code is enclosed in straight quotes because it contains spaces.

5.280 €

Master.OPPORTUNITY_AMOUNT(Numeric #,##0.00)

5.280,25

Master.OPPORTUNITY_AMOUNT(Currency)

5.280,25 €