Skip to main content

How to Format Number or Currency Values in Conga (Word)

Formatting Number Values

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

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

Example:
{ = 4 + 5 \# 00.00 } displays "09.00".
#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.

Example:
{ = 9 + 6 \# $### } displays "$ 15".
, (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. **

Example:
{ = NetProfit \# $#,###,### } displays "$2,456,800".
%, $, *, and so onIncludes the specified character in the result.

Example:
{ = NetProfit \# "##%" } displays "33%".
"positive; negative"Specifies different number formats for positive and negative results.

Example:
If the bookmark Sales95 is a positive value, the field { Sales95 \# "$#,##0.00;-$#,##0.00" } displays the value with regular formatting— for example, "$1,245.65". A negative value is displayed with a minus sign— for example, "-$ 345.56".
CurrencyFormats the value according to the Salesforce Locale, including a currency symbol, digit grouping symbol (“thousands separator”) and two decimal places

Example:
{ MERGEFIELD OPPORTUNITY_AMOUNT \# Currency }

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

** Note: May be used with =SUM fields, in addition to merge fields **
NumberFormats the value according to the Salesforce Locale, excluding a currency symbol, but including a digit grouping symbol (“thousands separator”) and two decimal places

Example:
{ MERGEFIELD OPPORTUNITY_AMOUNT \# Number }

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

** Note: May be used with =SUM fields, in addition to merge fields **
Number Value In WordsFormats the value according to the Salesforce Locale, converts a number value into words.

Example:
{=VALUE /* DollarText}

{=$94,000/ *DollarText}

​ninety-four thousand and 00/100
 
PercentFormats 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:
{ MERGEFIELD OPPORTUNITY_PROBABILITY \# Percent }

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

** Note: Not for use with =SUM fields **

Example 1:
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)”. ​
 
EXAMPLEOUTPUT
{ MERGEFIELD OPPORTUNITY_AMOUNT \# #,##0 }5,280
{ MERGEFIELD OPPORTUNITY_AMOUNT \# $#,##0 }$5,280
{ MERGEFIELD OPPORTUNITY_AMOUNT \# #,##0.00 }5,280.25
{ MERGEFIELD OPPORTUNITY_AMOUNT \# Currency }$5,280.25
{ MERGEFIELD OPPORTUNITY_AMOUNT \# Number }5,280.25
Example 2:
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)”.
 ​
EXAMPLEOUTPUT
{ MERGEFIELD OPPORTUNITY_AMOUNT \# #,##0 }5.280
{ MERGEFIELD OPPORTUNITY_AMOUNT \# #,##0 € }5.280 €
{ MERGEFIELD OPPORTUNITY_AMOUNT \# #,##0.00 }5.280,25
{ MERGEFIELD OPPORTUNITY_AMOUNT \# Currency }5.280,25 €
{ MERGEFIELD OPPORTUNITY_AMOUNT \# Number }5.280,25
Formatting a Currency Field

​Add a "picture switch" to the field.

​To do this: 

1. Right-click and choose "Toggle Field Codes"

​2. Remove "\*MERGEFORMAT", if it appears

3. Include a picture switch similar to "\# Currency" or "\# $#,##0"
Labels:

Comments

Post a Comment

Popular posts from this blog

How to create a custom button to open Visualforce page

Let's say that you are working in a large Org and different groups throughout the company use the same object, but each a little differently. Instead of overriding the standard "Edit" or "New" buttons, create a custom button. For example, there is a custom object on the standard Opportunity object and you want to launch a different page layout for your sales team for a custom quoting object. Create your "Quote" Visualforce page. Create the custom button on the custom object. Label: New API Name: New_Quote Type: List Button Content Source: OnClick JavaScript Behavior: Execute JavaScript Button or Link URL: window.open("/apex/InputVisualforcePageNameHere?RecordType=InputRecordTypeIdHere&retURL={!Opportunity.Id}&cancelURL={!Opportunity.Id}&saveURL={!Opportunity.Id}","_parent"); Edit the Opportunity page layout for the sales team and modify the buttons on the related list to add your custom button. In ...
Post a Comment
Read more

How to create the Conga Composer Button

Create  a Custom Conga Composer Button Conga Composer includes sample buttons on the following standard objects so you can easily copy and paste the base URL into your button.  Lead   Contact Account Opportunity Case Contract                       ​From Setup, click  Customize , select one of the above standard objects and click  Buttons, Links, and Actions ​Click on the  Conga Composer  button and copy the four lines in the Button or Link URL field 3. Click back to the main Buttons, Links, and Actions menu and click  New Button or Link      ​4. For the label, enter something that will describe the kind of document you will create     with Conga Composer, i.e. "AccountPlan" or "Invoice" ​5. For the Display type, choose either a  Detail Page Link  or a  Detail Page Button ​6. In the Button or Link URL text box, paste th...
Post a Comment
Read more