FLOOR
The following section describes the syntax and usage of the FLOOR function in ActivityInfo.
Description
The FLOOR function is used to round a value downwards to the nearest whole number.
Syntax
FLOOR(value)
| Argument | Required | Description |
|---|---|---|
| value | Yes | The value you wish to round downwards. The value must be numeric. |
Result
The nearest whole number when rounding down from the given value.
Example
We will be using the FLOOR function to calculate a rounded value from an argument.
Arguments
We will be using the Quantity Field "Value" with Field Code "VAL".
Formula
FLOOR(VAL)
Results
