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.
