Formula

Formula field value of the field is not stored within the database record, but is calculated on the values of other fields within that record. The calculation is called a formula. This formula consists of values from other fields and the results of functions.

Available Formula Functions

Operators:

• = plus

  – = minus

• = multiply

  / = divide

  ( ) = precedence

Additional options for Form fields:

• Formula: Enter calculation, formula, and functions. Press “@” key to get the list of functions available to choose. Fields has to be enclosed in square brackets “[ ]”. Go to Function Reference to see all the functions available.

• Fields: Field list available to be inserted in formula. You can click field name in field list to insert in formula field at cursor position.

• Display Format: Specify which field formatting details will be used to format the resulting formula value.