User Guides

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.

Click here for 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.