Formulas are used when a value in a field should be calculated according to specified parameters; eliminating the need to do so manually. This is especially useful in financial reports, pricing, payroll, etc.

That is, everywhere where the results obtained can vary, or better put, can be calculated using a mathematical formula.

The basic syntax is simple:

 Operand Operator Operand

Operands are constants ( plain numbers) or variables from PANTHEON. Variables are entered by placing them between hashes (#).

Example:

Variables that can be used in formulas depend on where the formula is used. For example, formulas for calculating prices can contain only variables that are related to prices. Available variables for specific formulas are explained in the related topics.

The following operators are available:

Other valid characters:

Formulas are calculated from left to right. Conditional statements can have any number of levels.

Related topics:

• Using Conditional Statements in Formulas
• Testing and Debugging Formulas
  • Testing Formula
  • Debugging Formulas