Totals

The following functions are available when calculating a total across multiple rows/groups of data:

Adding Totals

_AddTotal([NAME],[AMOUNT])

#	Type	Passing	Default	Name	Description/Comments
1	string	required	n/a	NAME	The name to identify the total
2	decimal	required	n/a	AMOUNT	The amount to add to the totals

{{_AddTotal("Amount1",ALIAS.PRICEASK)}}

_GetTotal([NAME],[FORMAT],[GROUP_LEVEL])

#	Type	Passing	Default	Name	Description/Comments
1	string	required	n/a	NAME	The name to identify the total
2	string	optional	#.##	FORMAT	The format of the number
3	boolean	optional	true	GROUP_LEVEL	Whether requesting the total for the grouped amounts or total amounts across all groups.

{{_GetTotal("Amount1","{0:C}")}}

_ClearTotals([NAME],[GROUP_LEVEL])

#	Type	Passing	Default	Name	Description/Comments
1	string	optional	n/a	NAME	The name to identify the total, or empty to clear all totals.
2	boolean	optional	true	GROUP_LEVEL	Whether clearing the group or global totals.

{{_ClearTotals("Amount1")}}

*NOTEThe output system automatically clears the group totals across each output group.