Operators and Functions

There are three types of operators that you may use in formulas: arithmetical, comparison and logical. Operators represent a certain simple operation that will be performed over certain values (like in maths, - stands for subtraction, * for multiplication, and so on.). To view the list of operations, refer to the Formula Language Reference.

Functions, similarly to operators, represent certain predetermined operations that will be carried out when formula result is calculated. Functions consist of a function name and a list of function arguments (separated by commas) in parentheses. Function arguments are values that will be used to calculate the function result; for arguments you may use literals, column references or variables. Functions, like column references, may be entered manually; however, unlike references, they are case sensitive.

For example, the Sum(number,...) function is used to sum up several values listed in parentheses. For its two arguments you can use literals, column references or variables. The Sum([Salary], 300) function, where [Salary] and 300 act as arguments, will add a bonus of 300 to the value retrieved from the Salary column.

If needed, functions can be nested within each other.

Next: Conditions