# Formulas

## Overview

Formulas let you define your own functions for use in expressions, which are used in Data Management tools such as Calculate and Filter.

Like projects and macros, formulas are fully version-controlled in the repository, so every time you edit a formula and save it, a new version is created. Any expressions using a formula will automatically detect new versions of a formula.

Defined formulas appear in the function tree of Data Management's expression editors. You can select a formula from the function tree and use it in an expression just like Data Management's built-in functions.

### Add formulas

To add a new formula to the repository:

In the repository, right-click the

**Formulas**icon, and then select**New Formula.**Specify a

**Formula name and Result Type.****Formula name**:**Result type**:

Specify all parameters used in your expression in the

**Input arguments**grid. Define Field and TypeEnter your formula in the Expression

Select

**Insert**to select defined functions or formulas.

Errors will be listed in the Errors and messages box. Select an error message to highlight the incorrect part of the expression.