Functions tab

Within the Functions tab, you must select the type of function you want to use, either System-Defined or User-Defined. System-Defined is the default.

Depending on which type of function is selected, one or two drop-down lists will appear below the radio group. If System-Defined is selected, the Function drop-down list will appear, allowing you to choose one of 14 predefined functions. If User-Defined is selected, two drop-down lists will appear, Core and Function. To select a function you’ve created, you must first select the core with which the function is associated. You can then select the desired user-defined function from the Function drop-down list.

Many of the system-defined functions convert a field’s storage type. For example, the CUR_STR function converts a currency control type field to a string control type field. The conversion doesn’t affect the way the field is stored in the table, only how its data is evaluated in the calculated or conditional expression.

Documentation Feedback