Logic

Function And()

Compares multiple values and returns true if all values are true or false if at least one input is false.

Syntax
And( e [, e…])

Function IIf()

Evaluates a true / false expression, and returns a parameter value if the expression is true and another if the expression is false.

Syntax
IIf( e, t, f )

Function IsTrue()

The isTrue() function evaluates determines if an expression is true or false, Returns 1 if true otherwise 0 if false.

This function can be used to convert string based True/False results into a numeric representation.

By default, this function will interpret the following as True: 1, T, True, Y, Yes

This function is not case sensitive, so the value ‘t’ and ‘T’ both evaluate to True. In addition to the built-in interpretation of True, this function can optionally be passed a second parameter to define an alternative value for True. Used in this way this function is similar to the IsEqual function.

Syntax

IsTrue( e [, c] )

Function NotContains()

NotContains() determines whether none of the values retrieved from a repeating section, page or data source matches a specified value. Note that the value must be an exact match, although it is not case sensitive. This is the opposite of the Contains() function.

Returns 1 if no values match or 0 if any values match.

This is an aggregate function

Syntax
NotContains( v, r1 [, r…])

Function Or()

Compares multiple values. Returns true if at least one of them is true.

Syntax

Or(e1 [, e…])

Function StringContains()

Syntax

StringContains(paramtr1,paramtr2)

The function checks whether or not the second parameter paramtr2 is present in string paramtr1.

Function GreaterThan, LessThan, EqualTo

This group of functions compare their parameters. A true result of 1 or a false result of 0 is returned. These functions are often used in conjunction with the IIf function to return a string or value other than 0 or 1.

Syntax

IsEqual( p[1], p[2], .., p[n] )

IsNotEqual( p[1], p[2])

IsGreaterThan( p[1], p[2])

IsLessThanOrEqualTo ( p[1], p[2])

Nested iif() formulas

Often, it is necessary to nest iif() functions to cater to scenarios where there are several possible input values.

For example, in the formula below, the [q1] reference has three possible values namely 1, 2,and 3 and resolves to the phrase Plane, Train, or Automobile.

Syntax

iif(isequal([q1],1),"Plane",iif(isequal([q1],2),"Train", "Automobile"))

Function Contains()

Contains() determines if at least one of the values retrieved from a repeating section, page or data source matches a specified value. Note that the value must be an exact match, although it is not case sensitive.

Returns 1 if any values match or 0 if no values match.

This is an aggregate function

Syntax
Contains( p1, p2[, p3…])

Mathematical

Mathematical Operators

Function Abs()

Returns a positive (absolute) version of the number passed in as a parameter.

Syntax

Function Average()

Returns the average of a series of numbers.

This is an aggregate function

Syntax

Average( r )

Function Round(), Ceiling() and Floor()

Returns the value passed into the first parameter, rounded to the number of decimal places defined by the second parameter, or to a whole number if the second parameter is not provided.

• Round – rounds to the closest given number of decimal places. For example, 0.1 becomes 0 while 0.9 becomes 1.
• Ceiling – rounds UP to the nearest given number of decimals. For example, 0.1 becomes 1 while 0.9 becomes 1.
• Floor – rounds DOWN to the nearest given number of decimals. For example, 0.1 becomes 0 while 0.9 becomes 0.

Syntax

Round( e , n )
Ceiling( e , n )
Floor( e , n )

Function Max() and Min()

Functions returns the highest and lowest number in a data set.

This is an aggregate function

Syntax

Max( r )

Min( r )

Function Sum()

The Sum() function returns the total of all numerical values in a data set.

This is an aggregate function

Syntax

Sum( r )