Numeric functions
- CEILING() : round a number up
- COUNTIF() : count values matching a condition
- STDEV() : calculate a standard deviation
- MEDIAN() : calculate a median
- AVERAGE() : calculate an average
- FLOOR() : round a number down
- INT() : extract the integer part of a number
- ROUND() : round a number
- MAX_NUM_ELEMENTS() : find the largest value (among linked elements)
- MIN_NUM_ELEMENTS() : find the smallest value (among linked elements)
- SUM_ELEMENTS() : add up the values of a linked column (sum)
- NB_ELEMENTS() : count the records in a linked column
- MAX() : find the largest value
- MIN() : find the smallest value
- SUBSTRACT() : subtract several columns
- SUM() : add up several columns