Skip to main content
Conga Support

SUM(ABOVE) in Word

In performing merges that include detail regions, you may wish to include the total of a numeric column. This can be accomplished in the Word® template.

See AutoSum(Above) if you are working with international currencies.

SUM(ABOVE)

Syntax

 {{=SUM(ABOVE)}}

Notes

The number of columns in the row with the SUM(ABOVE) field must match the number of columns in the rows above it. You can turn off table borders to “hide” cells if needed.

Usage

Product Quantity Total Price
{{TABLESTART:OPPLINEITEMS}}
{{OPPORTUNITY_LINEITEM_
PRODUCTNAME}}
{{OPPORTUNITY_LINEITEM_QUANTITY}} {{OPPORTUNITY_
LINEITEM_TOTALPRICE}}
{{TABLEEND:OPPLINEITEMS}}
    {{=SUM(ABOVE)}}

Returns on merge

Product Quantity Total Price
GenWatt Diesel 1000kW (Products) 2 200000
GenWatt Gasoline 2000W (Products) 1 150000
    350000
  • Was this article helpful?