1. Line Servicing Setup Guide
  2. Administration System
  3. User Defined Parameters
  4. Formula Definition

2.5.1 Formula Definition

The Formula Definition section allows you to define a mathematical expression of the formula to evaluate the parameter definition. The expression may consist of one or more sequenced entries. All arithmetic rules apply to the formula definition. If errors exist in the formula definition, the system displays an error message in this section when you choose Show Expression.
  1. In the Formula Definition section, perform any of the Basic Operations mentioned in Navigation chapter.
    A brief description of the fields is given below:

    Table 2-17 Formula Definition

    Field Do this
    Seq Specify the sequence number (the order in which the formula definition variable will be assembled and evaluated).
    ( Specify a left bracket, if you need to group part of your formula definition.
    Variable
    Select the variable from the drop-down list which consists of a validated list derived from user defined table type as indicated below:
    • For Number, system displays only numeric fields
    • For Date, system displays numeric + date fields
    • For String, system displays numeric + character fields

    Parameters for Account entity type in Customer Service is derived from:

    USER DEFINED: ACCOUNTS FORMULA PARAMETERS

    USER DEFINED: COMMON FORMULA PARAMETERS

    USER DEFINED: COMMON CUSTOMER SERVICE FORMULA PARAMETERS

    Parameters for Collateral entity type in Customer Service is derived from:

    USER DEFINED: COLLATERAL FORMULA PARAMETERS

    USER DEFINED: COMMON FORMULA PARAMETERS

    USER DEFINED: COMMON CUSTOMER SERVICE FORMULA PARAMETERS
    Constant Value
    Specify the constant value (optional).
    • For Number, system supports only numeric constants
    • For Date, system supports only numeric constants
    • For String, system supports both numeric and character constants

    Note: System displays an error indicating ‘VARIABLE OR CONSTANT VALUE IS REQUIRED’ if both Variable and Constant Value or None is provided.

    Mathematical Operator
    Select the math operator to be used on the adjacent formula definition rows, from the drop-down list. The list is derived and displayed based on data type / variable as indicated below:
    • For Number, system allows all numeric operators (+, -, x, and %).
    • For Date, system supports (+ and -) operators.
    • For String, system supports concatenation (i.e. +) operator.
    ) Specify a right bracket, if you are grouping part of your formula definition.
    Enabled Check this box to enable the formula and indicate that it is included when building a parameter definition.
  2. Perform any of the Basic Actions mentioned in Navigation chapter.
  3. In the Parameters section, click Show Expression. The mathematical expression appears in the Formula Expression section (in sequential order) in the Expression field.

Parent topic: User Defined Parameters