# Extend

Allows a value in a non-repeating field to be used with every repetition in a repeating field.

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

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas