ValueTable.Total

Syntax:

Total(<Column>)

Parameters:

<Column> (required)

Type: String.
Name of the column for which you want to calculate total.

Returned value:

Type: Number; Undefined.
Sum of values by all lines in specified column.

Description:

Sums up the values of all rows in the specified column.
If there is a single type defined for the column, totaling would cause an attempt to cast values to the Number type.
If no types are assigned to the column, totaling will include only values of the Number type, ignoring values of other types.
If there are multiple types in the column including Number, then totaling will include only values of the Number type, ignoring values of other types.
If there are multiple types in the column excluding Number, the result will be Undefined.

Availability:

Server, thick client, external connection, Mobile application (server).

    

1C:Enterprise Developer's Community