All functions should be in upper case. You need to append the trailing colon character to a function name.
CONCAT:(firstName, ' ', lastName)
IF:(EQUAL:(status, 'Complete', 'Complete', 'Not Complete'))`
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.
Fiscal year number, where X is a number (between 1 and 12) of the fiscal year start. E.g.
Number from 0 to 23.
Number from 0 to 59.
Month number w/ year. E.g.
Quarter number w/ year. E.g.
Fiscal quarter number, where X is a number (between 1 and 12) of the fiscal year start. E.g.
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.
CONCAT:(firstName, ' ', lastName).
Convert to lower case.
Convert to upper case.
Remove leading and trailing spaces.
Number of characters in string.
ADD:(2, 2) corresponds to
2 + 2.
SUB:(2, 1) corresponds to
2 - 1.
MUL:(2, 2) corresponds to `2 * 2..
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.
OR:(a, b, c) corresponds to SQL statement
a OR b OR c.
AND:(a, b, c) corresponds to SQL statement
a AND b AND c.
NOT:(a) corresponds to SQL statement