A function is a predefined, named
formula that performs a specific calculation and returns a single, specific value.
Each function returns a result of field type text, number, date, time, timestamp, or container.
Function parameters can be constants (such as 1.07 or “hello”), field references (such as InvoiceTotal),
expressions (such as 1 + 12), or other functions (such as the
NPV function). You can use spaces before or after the parentheses used to enclose the parameters, but spaces are not necessary. When a function requires more than one parameter, separate individual parameters with a
list separator, such as a semicolon.
Curly braces ({ }) surround optional parameters (for example, the Case function and
Choose function). An ellipsis (...) signifies that you can add more parameters, each separated by a semicolon (for example, in aggregate functions). Double quotation marks (“ ”) indicate a text string.