Extend
Allows a value in a non-repeating field to be used with every repetition in a repeating field.
Format
Extend ( non-repeatingField )
Parameters
non-repeatingField
- any non-repeating field (a field defined to contain only one value), or an expression that returns a reference to one
Data type returned
text, number, date, time, timestamp, container
Originated in version
6.0 or earlier
Description
Use the Extend function with calculations involving both repeating and non-repeating fields. Without the Extend function, the value in non-repeatingField
is used only with the first repetition in the repeating field.
Example 1
Extend(TaxRate) * Quantity * ItemPrice
returns 1.197, .6606, and 1.497 when TaxRate
contains .06; the repeating field Quantity contains 1, 3, and 5; and the repeating field ItemPrice contains 19.95, 3.67, and 4.99.
Example 2
Item Count * Extend(if(Company Size > 100; Reduced Price; Price))
returns $1250, $500, and $750 when Reduced Price
contains $50; the repeating field Item Count
contains 25, 10, and 15; and Company Size
is greater than 100. If Company Size
is less than 100 and Price
contains $100, this calculation returns $2500, $1000, and $1500.