QUE CORPORATION - Using Filemaker pro X

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 )

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