Define a Numerical Expression

A Numerical Expression is an Expression that performs mathematical calculations using a string of Tokens and mathematical symbols (example: Calculate the total cost of a Labor Cost Item by multiplying the work hours by the monetary rate).

If you need to use a number as part of the Expression, first create a Stored Value to represent that number, and then include the Stored Value in the Expression. This ensures that the system correctly converts the number. For example, if you want to divide the Incident.Cost by the number of work days in a week, create a Stored Value for the number of work days, then use it in the Expression.

To define a Numerical Expression:

  1. Create an Expression.
  2. In the Editor drop-down list, select Number.

    The Numerical Expression section opens.

  3. Define the Expression:
    1. Select the down arrow to open the Token Selector, and then select a value.
      Tip: Right-click anywhere in the Expression field to access the Token Selector.

      The Token displays in the Expression field.

      Numerical Expression with Token

    2. Type a mathematical symbol for the equation (+ to add, - to subtract, * to multiply, or / to divide).

      Numerical Expression with Token and Mathematical Symbol

    3. Select the down arrow to open the Token Selector, and then select a value.
      Tip: Right-click anywhere in the Expression field to access the Token Selector.

      The Token displays in the Expression field.

  4. (Optional) Add additional Tokens and mathematical symbols to the equation.
  5. Select Save.

Cherwell follows IEEE standards for rounding numerical values, specifically the round to nearest, ties to even rule.