Select a Function dialog box

The Select a Function dialog box allows you to select functions to use when defining an expression to import data. You can select a function in the following ways:

Search for a function by typing the function's name in the Search for a function field. As you type, functions that match your search text are displayed in the Select a Function pane. Click the name of the function and click OK to select it.
Browse for a function. From the drop-down list, select a function category to narrow the list of functions displayed in the Select a Function pane below.

Click the name of the function in the Select a Function pane and click OK to select it.

The functions in the Select a Function dialog box are grouped into the following categories:

Basic functions are basic mathematical functions like average, greatest, least, maximum, minimum, first, last, and so on. They are among the most commonly used functions when creating a calculation.
Date and Time functions provide date and time information, such as current date, the day of the week of a particular date, and so on.
Financial functions provide many standard financial calculations.
Internal functions include banding functions, which are used to differentiate the data displayed on a report, and pass-through functions like ApplySimple.
Logical functions include the IF and NOT logical operators.
Math functions are more complex functions than the simple operators found in the Basic functions category. This category includes exponential, logarithmic, and trigonometric functions.
Null/Zero functions determine how nulls and zeros are displayed on a report.
OLAP functions are relative functions, such as rank, running sum, moving average, and so on.
Rank and NTile functions are very similar to OLAP functions in behavior. The primary difference is that in the Rank family <Sortby uses only metrics, not attributes.
Statistical functions include a wide range of functions to perform statistical analysis on your data.
String functions work on text strings, performing tasks such as trimming and concatenating.

Related topics

Function Arguments dialog box
Importing data from a database