SUM keyword

Applies To

Form components

Component property: Data binding

Description

Evaluates to the numeric sum of the values of a property in a collection.

Syntax

SUM( “PROPERTY”( PropertyName ) )

Part	Description
`PropertyName`	Expression that evaluates to a string representing the name of a property of the IDO that returns the collection.

Remarks

A substitution keyword. Use the SUM keyword to specify the data binding of a read-only component. The sum is updated when the “StdFormLoadDerivedValues” event is generated during, for example, a Save or navigate operation. To force an update when the value of the property changes, use the “DEPENDENCY” keyword with the SUM keyword.

Example

The following example is a data binding specification for a read-only edit text box. The value of the component is the sum of the property values in the QuantityShipped column of a collection.

SUM(PROPERTY(QuantityShipped))