1. Double-click on the Field object.

2. DataEase displays the “Field Definition” dialog.

3. Click on the “Derivation” radio button.

4. DataEase opens the “Derivation Formula” editor.

5. Enter the Derivation Formula manually, or click on a selection from the four list boxes and the numerical keypad to enter field names, relationships, functions, operators, and numbers in the formula box.

6. When you finish entering the formula, click OK.

7. DataEase checks the spelling and syntax. If DataEase finds an error, it positions the cursor at the start of the invalid word or expression. If the formula is valid, DataEase saves it as part of the field definition.

NOTE: Use the numeric keypad to enter numbers into a Derivation Formula. Constant values and the associated quotation marks must be entered into a formula manually. If a Field Name or a relationship name contains more than one word, it must be enclosed in quotation marks (e.g., count of “FAMILY MEMBERS” “LAST NAME”). Otherwise, you can omit the quotation marks (e.g., highest of MEMBERS ROOMS). Constant text values, like the state abbreviation “CT” must also be entered in quotation marks.