Math Operators

These are the math operators that can be used within formulas.

+

plus operator combines two numerical values into a sum

Example: TASK.estimatedCost + 22.45

-

minus operator subtracts one numeric value from another to find their difference 

Example: PROJECT.fixedCost - PROJECT.estimatedCost - 1200

/

divide operator splits a numeric value into a specific number of equal parts to determine the quotient

Example: BOOKING.estimatedDuration / 48.0 

*

multiply operator add a numeric value to itself a specific number of times to calculate the product

Example: STAFF.payAmount * 1.5

%

modulo operator divides one numeric value by another and returns the remainder rather than the quotient

Example: PROJECT.estimatedCost % 1000000

Boolean Operators

These are the boolean operators than can be used within formulas.

eq

is equal to the provided value

Example: PROJECT.STAGE.name eq "Completed"

neq

is not equal to the provided value

Example: LOCATION.name neq "Los Angeles"

lt

is less than provided value

Example: ACTIVITY.startTime lt ACTIVITY.closeTime

lte

is less or equal than provided value

Example: TASK.actualCost lte TASK.estimatedCost

gt

is greater than provided value

Example: BOOKING.estimatedCost gt 500.00

gte

is greater or equal than provided value

Example: REBATE.rebate gte 25.0

Aggregation Boolean Operators

These boolean operators can be used in aggregation filters.

inside 

is greater than the first and less than second provided value, range e.g. "1|3"

outside

is less than the first or greater than the second provided value, range e.g. "1|3"

between

is greater than or equal to the first and less than the second provided value, range e.g. "1|3"

within

is on the list of provided values, array e.g. "1|2|3"

without

is not on the list of provided values, array e.g. "1|2|3"

contains

is string of letters inside the text matching provided value

!contains

is not string of letters inside the text matching provided value

containsFuzzy

is one word inside the text similar to the provided value

!containsFuzzy

is not one word inside the text similar to the provided value

containsWord

is one word inside the text matching provided value

!containsWord

is not one word inside the text matching provided value

containsPhrase

is sequence of words matching provided value

!containsPhrase

is not sequence of words matching provided value

containsPrefix

is one word inside the text beginning with provided value

!containsPrefix

is not one word inside the text beginning with provided value

containsRegex

is one word inside the multiple lines text matching regular expression provided value

!containsRegex

is not one word inside the multiple lines  matching regular expression provided value

ending

is string of letters ending the text matching provided value

!ending

is not string of letters ending the text matching provided value

fuzzy

is entire text similar to the provided value

!fuzzy

is not entire text similar to the provided value

prefix

is text beginning with the provided value

!prefix

is not text beginning with the provided value

regex

is text matching regular expression of provided value

!regex

is not text matching regular expression of provided value

is

is entire text matching in insensitive case provided value

has

is string of letters inside the text matching provided value in insensitive case

hasEntry

is aggregated list of quantified entries having provided value, e.g. ,["CONTACT.phones", "hasEntry", "home:123"]

hasEntry

is aggregated list of entries having provided value, e.g. ,["CONTACT.websites", "hasEntry", "janus"]