GREATER (>)

The following section describes the syntax and usage of the GREATER (>) function in ActivityInfo.

Description

The GREATER (>) function is used to determine whether a certain value is greater than another.

Syntax

value1 > value2

Argument Required Description
value1 Yes The value you wish to test is greater than another.

The value must be numeric.
value2 Yes The value you wish to test against.

The value must be numeric.

Result

  • TRUE if value1 is greater than value2.
  • FALSE if value1 is equal to or smaller than value2.

Example

We will be using the GREATER (>) function to test whether a given value is greater than another, and using the IF function to return a value.

Arguments

We will be using the Quantity Field "Age" with Field code "AGE".

Formula

IF(AGE > 18,1,0)

Results