Register
Sign In
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.
Product: . Written by alembagheri tahmas 07/12/13 at 13:37:32
Product: DataEase for Windows 7.x. Written by George Washington 11/04/14 at 08:26:17
Product: DataEase 8 Reporter. Written by eduardo paez 02/05/14 at 14:40:11
Product: . Written by Marco Marchesi 15/02/16 at 14:50:46
Product: Dataease [{8}]FIVE. Written by Chamil Rajindra 21/02/19 at 10:17:46
Product: . Written by afonso santos 28/10/19 at 00:50:14
Product: . Written by Grossi Gioacchino 18/11/19 at 14:33:44
Product: Dataease [{8}]FIVE. Written by Rainer 22/03/21 at 11:13:10
Product: Dataease [{8}]FIVE. Written by Rainer 08/06/21 at 14:12:40
Product: . Written by Hiralal Rampul 01/12/21 at 17:47:10
Copyright © DataEase Limited. All Rights Reserved
