Extend()

Extend()

Category: Repeating

Syntax: Extend ( non-repeatingField )

Parameters: non-repeatingField ”any non-repeating field (a field defined to contain only one value).

Description: Allows a value in non-repeatingField to be used in every repetition in a calculation defined as repeating. Without Extend() , only the first repetition of a repeating calculation field can use the value of a non-repeating field.

Examples:

Given a number field RepCommission , defined to hold 3 repetitions, a non-repeating number field ( SalePrice ), and repeating calculation field ( SalesCommission ), defined as follows :

 Round ( RepCommision * Extend ( SalePrice ) ; 2 ) 

RepCommission	SalePrice	SalesCommission
.10	18.00	1.80
.12		2.16
.15		2.40

Without the Extend() function, only the first repetition of SalesCommission would have returned the correct value.