Sum (Above)

Created by Docs Made Easy, Modified on Fri, 11 Jul at 4:00 AM by Docs Made Easy

Available In: Docs Made Easy Basic and Pro

Parameter Value : {{Sum(Above)}}

Parameter Requirements : None

Parameter Description : The Sum (Above) parameter in Docs Made Easy is used to calculate the sum of all numeric values in a column directly above the cell where the parameter is placed. This is particularly useful in scenarios where you're working with tables that display itemized data.

Note:

The {{Sum(Above)}} parameter must be placed in the same column as the numeric values you wish to total. Misalignment will result in incorrect or empty output.

Example -

Syntax in the Table

Product Name	Quantity	Price
{{TableStart:Opportunity.r.OpportunityLineItems}}{{Name}}	{{Quantity}}	{{TotalPrice}}{{TotalPrice}}{{TableEnd:Opportunity.r.OpportunityLineItems}}
		{{Sum(Above)}}

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