Menu

aggregate(...)

Updated: 2022-02-18

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

Example 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