Create System-Wide Calculated Fields

Use the Calculated Fields form of General Configuration to create a global calculated field for a specific report. You can then use Role Security to specify the roles that have access to the calculated field.

Your security role must have the appropriate menu access for you to be able to create system-wide calculated fields.

To create system-wide calculated fields:

  1. From the Vision Navigation menu, click Configuration > General > Calculated Fields.
  2. On the Calculated Fields form, select one of the following actions:
    Option Description
    To create a new field Click New > New Calculated Field.
    To create a new field from a field already open on the form Select the field and click New > Copy Current Calculated Field. On the refreshed form, modify the fields and save the record as a new calculated field record.
    To create a new field from a field currently in the list Click New > Select Calculated Field to Copy. Select the field, modify it, and save it as a new field.
  3. Complete the fields on the form.
  4. Click Check Calculation to verify that the formula syntax is valid.
  5. Click Save. The field that you add displays in the list of fields on the Column tab of the report. To have the field display on the report, you need to select it on the Columns tab.