Choose where you’d like to start

Sum

Note:

The sum function in the "aggregate records" deluge task returns the sum of all values of a specified field from records fetched using a criteria.

The criteria is mandatory.

This function can be applied to the following field types:

Based on the specified field, the data-type of the returned value could be one of the following:

If the specified field type is Number, or Formula(bigint), the data type of the return value will be number.
If the specified field type is Percent, Currency, Decimal, or Formula(decimal), the data type of the return value will be decimal.

<variable> = <form_link_name> [<criteria>].sum(<field_link_name>);

Parameter	Description
<variable>	Variable which will hold the returned value.
<form_link_name>	Link name of the form from which the records will be fetched.
<criteria>	Criteria based on which the records will be fetched.
sum(<field_link_name>)	Link name of the field to which the sum function will be applied. The "sum" aggregate function can be applied to the following field types: Number Percent Currency Decimal Formula (numeric)

If you wish to fetch all records of the specified form, use the following script as criteria:
[ID != 0]

It is advisable to fetch all records only when absolutely needed. Fetching all records generates a load resulting in performance issues.

When a record is Created
On Load	Yes
On Validate	Yes
On Success	Yes
On User input	Yes
Subform on add row	Yes
Subform on delete row	Yes
When a record is Created or Edited
On Load	Yes
On Validate	Yes
On Success	Yes
On User input	Yes
Subform on add row	Yes
Subform on delete row	Yes
When a record is Edited
On Load	Yes
On Validate	Yes
On Success	Yes
On User input	Yes
Subform on add row	Yes
Subform on delete row	Yes
When a record is Deleted
On Validate	Yes
On Success	Yes
Other workflow events
On a scheduled date	Yes
During approval process	Yes
During payment process	Yes
In a Custom Function	Yes
In an Action item in report	Yes

The following script returns the sum of values of "amount" field from the fetched records.

EmployeeDetails = Employees [ ID != 0 ].sum(amount);