Adding Calculated Fields

To open the Manage Calculated Fields dialog box:

  1. Open Query Builder.
  2. Click Calculations.
Note: Only the System Administrator can access this page.

To add calculated field:

  1. Open the Query Builder, and click Calculations.
    This button only appears if you are logged on as Admin.
  2. Click Add.
  3. Click the Properties tab.
  4. In the Name/Alias field, specify a name that describes the purpose of the calculation.
    The calculation name appears only in the Calculation Manager.
  5. In the second field, specify a name to be used in the calculation. It cannot contain any spaces or symbols. This is a required field. You cannot create a calculated field until this has been set.
    When the calculated field is used in constructing a plugin or query, this name is displayed in the list of available fields.
  6. From the Base Table drop-down arow and select the main table used to create the calculated field.
    If you are joining two tables, this is the parent table.
  7. Click the Calc. Type drop-down arrow and select a Calculation Type.
  8. Specify a Description if you want to have a longer description of the field available
  9. Click the Calculation tab.
  10. Determine if the values you want to use for the calculated field are in the selected Base Table.
    The table displayed in the upper list view is the table you selected in the Properties tab.
  11. If the base table does not contain the values you need, change the base table rather than creating a join. Click the Properties tab and select another base table.
  12. Create the calculation.
    1. Click + or - to expand or collapse the list of tables and fields to find the first field for the calculation.
    2. To add a field, click the field in the upper box to add it into any position within the calculation.
      This is the first field in the calculation.
    3. Do one of the following:
      • Click an operator if you are creating a numeric calculation.

        You must insert an operator between fields in a numeric calculation.

      • For a string, you do not need to pick an operator, but you may want to insert a space for the sake of appearance.
    4. Click another field in the tree view to add it to the lower tab view or specify an integer.
    5. Continue adding fields as necessary to build the calculated field.
    6. Use brackets to group calculations. To insert a bracket, place your cursor in the calculation where you want to insert a bracket and click a bracket button. You must have both a beginning and ending bracket.
  13. Click OK.
  14. Click Close.
Parent topic: Using Calculated Fields
Related topics