AUTO SUM ABOVE

Created by Docs Made Easy, Modified on Mon, 8 Sep at 6:37 AM by Docs Made Easy

Available In: Docs Made Easy Basic and Pro

Parameter Value : AUTOSUM(ABOVE)

Parameter Requirements : Must be combined with a CurrencyCulture parameter

Parameter Description : The AutoSumAbove parameter calculates the sum of all numeric values in the same column directly above the cell where it is placed, similar to the Sum(Above) parameter.

Unlike Sum(Above), the AutoSumAbove parameter applies currency formatting automatically using the specified CurrencyCulture setting. This ensures totals are displayed in the correct regional currency format, making it ideal for multi-currency templates and documents with international audiences.

Example -

Syntax in the Table

Product Name	Quantity	Price
{{TableStart:Opportunity.r.OpportunityLineItems}}{{Name}}	{{Quantity}}	{{TotalPrice \# CurrencyCulture1}}{{TableEnd:Opportunity.r.OpportunityLineItems}}
		{{AUTOSUM(ABOVE)\# CurrencyCulture1}}

Output

Product Name	Quantity	Price
Burlington Textiles Weaving Plant Generator GenWatt Diesel 1000kW	1	$10000
Burlington Textiles Weaving Plant Generator SLA: Bronze	2	$ 2000
		$ 14000

Note:

Use AutoSumAbove when totals must respect regional currency formatting. If only numeric addition is required (without formatting), use the standard Sum(Above) parameter.