sumSubtask - Sum calculation from subtasks

Description

The function sumSubtask enables the calculation of a sum based on a given expression exclusively for the subtasks of a task. This function is useful for calculating aggregated values only for the related subtasks.

Syntax

sumSubtask('expression')

Arguments

Return Type

The function returns the sum of the specified expression for subtasks only.

Example (Standard Fields)

Assume you have a main task with the following subtasks:

The fields Actual Costs / Planned Costs are, in this example, two standard fields from the subtasks.

To calculate the sum of the Actual Costs field from the subtasks, use:

sumSubtask('actualcosts')

Result: 1700

To calculate the sum of the Planned Costs field from the subtasks, use:

sumSubtask('costs')

Result: 35

Example (Flavors)

Assume you have a main task with the following subtasks:

The field Invoice Amount (net) is, in this example, a number-type flavor used in subtasks.

To calculate the sum of the flavor Invoice Amount (net) from the subtasks, use:

sumSubtask('flavor("Invoice Amount (net)")')

Result: 1700