Skip to main content
Conga Support

Creating Word Calculation Fields

 This method is not supported by Conga. You can create calculated fields in Salesforce. Conga can easily map those values to the Templates. Do not use dynamic culture codes. 

You can leverage Microsoft Word®’s for simple calculations in Word templates.

  1. You start by inserting a traditional word field by going to Insert / Quick Parts / Formula, then click the Formula button on the pop-up.
  2. Then put numeric fields, operators and a placeholder for any mergefields desired into your Formula:
    Then right click to toggle open your formula:
    { =("Mergefield1" * "Mergefield2") / 100 } 
  3. Now we can then replace the Mergefield1 text with a word traditional merge field using insert / quick parts / field then mergefield. Then you must nest your merge fields inside of your formula:
    { =(«Amount 1» * «Quantity 1») / 100 }
  4. When you merge your document, Conga® maps the values to the merge fields and Microsoft Word executes the calculations.

Here are some additional details on Word Calculation fields and operators: https://support.office.com/en-us/art...c-ae3b22b7eb5e

  • Was this article helpful?