Skip to main content
Conga Support

Formatting Numeric Values in PowerPoint

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.

List of parameters

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.

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.

%, $, *, and so on

Includes the specified character in the result.

"positive; negative"

Specifies different number formats for positive and negative results.

Currency

Formats the value according to the Salesforce Locale, including a currency symbol, digit grouping symbol (“thousands separator”) and two decimal places

Example:

{{OPPORTUNITY_AMOUNT \# Currency}}

Currency0

Formats the value according to the Salesforce Locale, including a currency symbol, digit grouping symbol (“thousands separator”) and zero decimal places

Example:

{{OPPORTUNITY_AMOUNT \# Currency0}}

In Conga Composer solutions, you can override the Salesforce Locale with the “CurrencyCulture” or “Culture” parameter.

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:

{{OPPORTUNITY_AMOUNT \# Number}}

Number0

Formats the value according to the Salesforce Locale, excluding a currency symbol, but including a digit grouping symbol (“thousands separator”) and zero decimal places

Example:

{{OPPORTUNITY_AMOUNT \# Number0}}

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:

{{OPPORTUNITY_PROBABILITY \# Percent}}

Tips and Tricks

In Conga Composer solutions, you can override the Salesforce Locale with the CurrencyCulture or Culture parameter.  See the Conga Composer Configuration Guide for details.

Examples

Here are some common examples of the number appearance parameter. Assume that the field we are formatting is OPPORTUNITY_AMOUNT and that it contains 5280.25 and the Salesforce Locale is “English (United States)”.

Example

Output

{{OPPORTUNITY_AMOUNT \# #,##0}}

5,280

{{OPPORTUNITY_AMOUNT \# $#,##0}}

$5,280

{{OPPORTUNITY_AMOUNT \# $#,##0.00}}

$5,280.25

{{OPPORTUNITY_AMOUNT \# Currency}}

$5,280.25

 

Now assume we are formatting the same field value as above, however, the Salesforce Locale is “German (Germany)”.

Example

Output

{{OPPORTUNITY_AMOUNT \#  #,##0}}

5.280

{{OPPORTUNITY_AMOUNT \#  “#,##0 €”}}

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

5.280 €

{{OPPORTUNITY_AMOUNT \#  #,##0.00}}

5.280,25

{{OPPORTUNITY_AMOUNT \# Currency}}

5.280,25 €