Mathematical functions

Several tasks such as Aggregator, Condition, and Notification support a powerful set of mathematical functions:
Most probably you are already familiar with them and used these ones in SQL databases, Microsoft Excel, or Google Spreadsheets.
Formula
Meaning
Example
AVG(field_name)
Average value in the input data set
AVG(amount)
SUM(field_name)
A sum of values in the input data set
SUM(amount)
COUNT()
Number of rows in the input data set
FIRST(field_name)
First value in the input data set
LAST(field_name)
Last value in the input data set
MAX(field_name)
Max value in the input data set
MAX(amount)
MIN(field_name)
Min value in the input data set
MIN(amount)
ROUND(field_name, precision, "floor|ceil")
Round a number up or down with a certain precision
ROUND(tax, 2, "floor")
NOW()
Current timestamp