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
