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