All functions should be in upper case. You need to append the trailing colon character to a function name.

Examples:

`CONCAT:(firstName, ' ', lastName)`

`IF:(EQUAL:(status, 'Complete', 'Complete', 'Not Complete'))``

E.g. `IF:(a, '1', '0')`

– if 'a' is true then return '1'; return '0' otherwise.

Pattern matching. E.g. `LIKE:(name, 'Cloud%'`

) will give true for 'name' equal to 'Cloud Basic' and 'Cloud Enterprise'.

Negation of LIKE.

Check whether two arguments are equal. E.g. `EQUAL:(status, 'Complete')`

corresponds to SQL statement `status = 'Complete'`

.

Negation of equal.

Check whether a > b. E.g. `GREATER_THAN:(amountConverted, 1000.00)`

corresponds to SQL statement `amountConverted > 100.00`

.

Check whether a < b.

Check whether a >= b.

Check whether a <= b.

Check whether value is NULL. E.g. `IS_NULL:(sicCode)`

– checks whether Sic Code field is not set.

Negation of IS_NULL.

Check whether a value is within a set of values. E.g. `IN:(stage, 'Closed Won', 'Closed Lost')`

will give true is stage is 'Closed Won' or 'Closed Lost'.

Negation of IN.

Returns the first non-NULL value in the list. E.g. `COALESCE:(dateStart, createdAt)`

will return value of createdAt if dateStart is not set.

Month number. From 1 to 12.

Week number. Sunday is a first day of week.

Week number. Monday is a first day of week.

Number from 1 to 7.

Number from 1 to 31.

Year number.

Fiscal year number, where X is a number (between 1 and 12) of the fiscal year start. E.g. `YEAR_3`

.

Number from 0 to 23.

Number from 0 to 59.

Month number w/ year. E.g. `2019-05`

.

Quarter number w/ year. E.g. `2019_1`

.

Fiscal quarter number, where X is a number (between 1 and 12) of the fiscal year start. E.g. `QUARTER_3`

.

Week number w/ year. E.g. `2018/4`

. Sunday is a first day of week.

Week number w/ year. Monday as a first day of week.

Current date and time.

Time zone converion. E.g. `TZ:(createdAt, -10.5)`

will apply -10:30 offset.

Concatenate. E.g. `CONCAT:(firstName, ' ', lastName)`

.

Convert to lower case.

Convert to upper case.

Remove leading and trailing spaces.

Number of characters in string.

Addition. E.g. `ADD:(2, 2)`

corresponds to `2 + 2`

.

Subtraction. E.g. `SUB:(2, 1)`

corresponds to `2 - 1`

.

Multiplication. E.g. `MUL:(2, 2)`

corresponds to `2 * 2..

Division. E.g. `DIV:(2, 4)`

corresponds to `2 / 4`

.

Returns remainder of a number divided by another number. E.g. `MOD:(6, 4)`

corresponds to `6 % 4`

.

The largest integer value not greater than the argument.

The smallest integer value greater than or equal to the argument.

Round a number to a specified number of decimal places. E.g. `ROUND:(value,2)`

.

E.g. `OR:(a, b, c)`

corresponds to SQL statement `a OR b OR c`

.

E.g. `AND:(a, b, c)`

corresponds to SQL statement `a AND b AND c`

.

E.g. `NOT:(a)`

corresponds to SQL statement `NOT a`

.