Menu

aggregate()

Updated: 2023-02-02

Aggregate amounts from a field on each copy of a multi-copy form and adds them together.

Code Result
{{CurrentClient.T2125Forms[0].T2125.Expenses.GrossProfit}}
{{CurrentClient.T2125Forms[1].T2125.Expenses.GrossProfit}}

17776 (on the first T2125)
82738 (on the second T2125)

{{aggregate(CurrentClient.T2125Forms,"T2125.Expenses.GrossProfit")}}

100514

{{format(aggregate(CurrentClient.T2125Forms,"T2125.Expenses.GrossProfit"))}}

100,514