Functions take part in the calculation and take other elements as argument.
There are two main types of functions :
- Calculation functions (like Arithmetic functions *, /, -, +, Abs, … or String functions Concat, Left, …)
- Aggregation functions (SUM, Count, AVG, …)
Most functions require arguments. A function argument itself can be anything :
Any missing item will be displayed as a ? question mark.
Browsing for a function
Functions can be browsed from the Functions container at the bottom :
This list can be filtered by function type, or by selecting All functions :
Adding a function to the Expression
To add a function to the Expression, simply drag it from the list into the Expression :
When adding a function on the ? question mark, the function will take this place.
Replacing an existing function
Browsing on the function
To replace a function in an Expression, it’s possible to click on the function to be replaced, and select a replacement function :
Wrapping an Expression into a function
Maybe you have started creating an Expression, but now you want to make it an argument to a new function.
To wrap part of an Expression into a function, it’s possible to drag the function from the list and drop it onto the Expression part to be wrapped :