Calculated Field Expression Dialog Box

Use the Calculated Field Expression dialog box to create the calculated field expression.

Contents

Field Description
Name This field is read-only and displays the name of the field entered in the New Calculated Field dialog box.
Expression Use this field to create the expression.
  • The expression may contain mathematical operators:
    • Add (+)
    • Subtract (-)
    • Multiply (*)
    • Divide (/)
    • Group (( ))
  • The expression may contain any property from the Applies to Table field that has a numeric data type.
  • Mathematical operators are evaluated according to the normal rules of precedence:
    • Cobra performs grouping operations before multiplication and division operations.
    • Cobra performs multiplication and division operations before addition and subtraction operations.
Applies to Table This field is read-only and displays the value selected in the New Calculated Field dialog box.
Data Type Use this field to select the data type.
Your options are:
  • Integer
  • Decimal
Note: This field does not filter the fields displayed in the Fields dialog box. Cobra allows you to select integer and decimal data types; nullable data types will be supported in future releases.
Currency This checkbox is currently not in use but will be required in future releases.
Fields Click this button to display the Fields dialog box.