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 | |
Last modified 4mo ago