Adding Calculated Fields from the Report Manager

To add a Calculated Field using the Report Manager:

  1. Open the Report Manager.
  2. Select a Report, right-click, and then select Edit Report Properties.
  3. Click Calculated Fields.
  4. Follow these steps:
    1. Click Add.
    2. Specify a Name for the Calculated Field. Note that names cannot contain spaces.
    3. Select the Business Object to associate with the Calculated Field.
    4. From the Data Type drop-down list, select one of the four data types recognized by the Report Designer:
      • Date/Time:

        A Date/Time data type allows you to build an Expression to perform date/time calculations (example: Calculate a fifteen minute warning for an SLA).

      • Logical:

        A Logical data type allows you to build an Expression to use one or more conditions to return a true or false value (example: Incident.Status does not equal Closed).

      • Number:

        A Number data type allows you to build an Expression to perform mathematical calculations using a string of Fields and mathematical symbols (example: Calculate the total cost of a Labor Cost Item by multiplying the work hours by the monetary rate).

      • Text:

        A Text data type allows you to build an Expression to display a string of Tokens and text (example: Return either "Open" or "Closed," depending on the status of a record).

    5. Select the Expression:
      • Stored Expression:

        Click the Ellipses button to select an existing Cherwell Expression. See About Expressions for more on Expressions.

      • Custom Expression:
        Click the Expression button to create a custom Expression. For more information, see the Define Expression topic for the Data Type selected:
© Copyright 2018 Cherwell Software, LLC. All rights reserved.