Insert Function dialog

Use this dialog to select a function to add to a formula in the "Edit Column Formula dialog: Column Formula tab."

For more information, see:

• "Editing the Formula for a Column"

• "How Are KPIs Evaluated?"

• Appendix D, "Logical SQL Reference"

Components

Functions

Use this tree to select a function to add to a formula. Expand a function group to show a list of functions within that group.

Selected

Displays the name of the function that is currently selected in the Functions tree.

Syntax

Displays the syntax of the function that is currently selected in the Functions tree.

Where

Displays descriptions of the arguments for the syntax.

Example

Displays an example of the function.

Description

Displays a description of the function that is currently selected in the Functions tree.

Notes

• When you click the f(...) button in the Edit Column Formula: Column Formula dialog (or the Edit Formula dialog), if:

  • Some text is selected in the Formula area, then the selected text is incorporated into the inserted function formula when you click OK.

  • If no text is selected in the Formula area, then the function's expression is inserted and the first argument (denoted by tokens expr or expr1) is automatically selected when you click OK.