Dynamic Expression Editor Dialog Box 

You access the Dynamic Expression Editor dialog box by clicking the Function (fx) icon displayed to the right of an attribute or property field that supports dynamic expressions.

The Dynamic Expression Editor dialog box contains the following areas:

·          Expression pane: The area on the top left of the dialog box enables you to construct dynamic expressions. You can write the expression as free text, or you can create it by dragging functions from the Function pane to the Expression pane. When you drag a function to the Expression pane, the required syntax is displayed. When you define a dynamic expression, prefix it with an equal (=) symbol. In certain cases, the equal (=) symbol is added automatically when you drag an item to the Expression pane.

·          Function pane: The area on the right of the dialog box displays a list of expandable nodes that group functions into the following categories:

¡        Data Fields, which contains all of the fields available from the data services in your model. This can be useful if, for example, you want a particular action type, such as a hyperlink, to represent a specific output in a query.

¡        Recently Used, which provides easy access to the functions you used last, up to a maximum of eight functions.

¡        All available functions, divided into the following categories: Text Functions, Numeric Functions, Date Functions, Time Functions, Quantity Functions, Conditional Functions, and Scientific Functions.

○       Operators, which lists all the mathematical, logical, and comparison operators available for use in the expression.

A descriptive tooltip is provided for each function. In addition, the syntax of the function is displayed after its name, and the icon to the left of each function represents the data type returned when the function is evaluated, as follows:

Icon	Data Type
	Boolean
	Date
	Number
	Quantity
	Text
	Time

·          Description field: The area below the Expression pane enables you to add any text related to the current expression, such as a reminder or a note to other users. Click anywhere in the field to open a Description dialog box in which you can enter, view, or modify descriptive text. Then click OK to close the dialog box and enter the text into the Description field.

·          Message pane: The area below the Description field displays the validation results returned for the expression when you click the Check button. For more information, see Messages in the Dynamic Expression Editor Dialog Box.

For a step-by-step description of how to use the Dynamic Expression Editor dialog box, see Defining Dynamic Expressions.