Formula Builder

To access this screen:

• Formulae are used throughout DTS to calculate variable values, for example:

  • On the Project Settings >> Production Fields >> Formula screen. See Add a Calculated Production Field.

  • On the Project Settings >> Text Fields >> Formula screen. See Add a Calculated Text Field.

  • On the Project Settings >> Date Fields >> Formula screen. See Add a Date Field.

  • On the Project Settings >> Internal Fields >> Formula screen. See Internal Fields.

  • Right-click a task and select Field Formula Details. See Production Field Formula Details.

You use this screen to define a formula for your production, text and date fields. Also see Functions.

This screen has three tabs:

• Expressions - See below.
• Lookups - See Lookup Tables.
• Constants - See Global Constants.

Expression tab

You can either enter an expression directly into the text field at the top of the screen, or you can construct it from elements provided below.

Field	Description
Fields	Displays the list of the currently defined fields. To add a field to the expression, scroll down to the field and double-click. The field is added to the Expression. Note: You can enter the name of the field, if you know it, but if you add the field to the expression by double-clicking the name, you make sure that the name of the field is correct. To add a defined Lookup: Double-click on the lookup as displayed in the <list of Lookups>. The correct expression to add the selected lookup is added. Select the field to which the Lookup is to be applied from the <list of Fields>. Click OK.
Functions	Displays the list of all the functions that you can use. To add a function to the expression, scroll down to the function that you need and double-click. Note: You can enter the name of the function, if you know it, but if you add the function to the expression by double-clicking the name, you make sure that the name of the function is correct. See below for additional comments relating to functions.
Constants	Displays the list of defined global constants. To define a new global constant, do one of the following: Select Project Settings >> Global Constants and define the constant. Select the Constants tab and define the constant.
Lookup Tables	Displays the list of defined Lookups, if you have any defined. To add a defined lookup to the expression, scroll down to the lookup and double-click. The correct expression to add the selected lookup is added.

Related topics and activities

• Project Formulae

• Add a Calculated Production Field

• Functions