Download page Formatting Numeric Values in PowerPoint.
Formatting Numeric Values in PowerPoint
The number formatting parameter begins with \#, followed by any combination of the following parameters. 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}}
In Conga Composer solutions, you can override the Salesforce Locale with the CurrencyCulture or Culture parameter.