To create a derived field

1.	From the configuration window of a process that supports derived fields, click Derived Fields.

The Create Derived Field window appears.

2.	In the Field Name field, enter a name for the new derived field.

All derived fields previously created in this process appear in the Field Name drop-down list. To create a new derived field, enter a different name.

3.	Select the Make Persistent checkbox if you want to store and pass on the calculated values for this field.

Enter an expression for the derived field directly in the Expressions text box or click Formula Helper to use the Query Helper. You can also use the fields listed in the Fields available for expression list by selecting a field name and then clicking <-Use to insert the field name into the Expression text box.

You can define a derived field to be a null value. Use NULL to return a null value for a snapshot or NULL_STRING to return a null value with a string datatype if you want the derived field to be used with a Campaign macro.

You can enter a string in a derived field as a constant. If you use a string, it must be surrounded by double quotation marks. For example, "my string". No quotation marks are required for numeric strings.

5.	(Optional) Click Check Syntax to verify the syntax of the derived field expression you have entered.

This will display either an error message (if there is a problem) or else indicate Syntax check OK if the syntax is correct.

6.	Click OK to save the new derived field and return to the process configuration dialog.