Like a virtual table, a calculated field doesn't physically exist but is defined only in the data dictionary. For example, most order entry systems don't store the extended price of an item, but derive it from the unit price multiplied by the quantity. However, you may want your users to be able to report on extended price, so you would create a calculated field for it. Calculated fields are shown with this icon in the TreeView:

To create a new field in a particular table, click the Create button () when the Fields node or a specific field node in that table is selected in the TreeView; alternatively, you can click the drop-down arrow beside the Create button and choose Create Field from the menu, or choose Create Field from the Objects or shortcut menus.

Enter the various properties for the field in the Main page of the properties pane, and in the Calc pane, enter the formula used to calculate the value for the field in the Expression property.

See Also

Creating a Virtual Table | Field Properties