# 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`.