FloorI

Syntax

FloorI(Input: Variant, Precision: Variant)

Parameters

Input. The variable, which points must be rounded

Precision. The multiple, to which it is necessary to round.

Description

It returns the result of variable points rounding up to the nearest multiple of significance with a lack. The variable must only contain integer values.

Comments

Use the Floor function to round points of the variable containing not only integer values.

Example

Formula Result Application
= FloorI({Brazil|BCA},3)

The Brazil|BCA factor observations are rounded down to the nearest number that is multiple of three. An error occurs if the factor contains real values.

It can be used in formulas of calculated series of time series database and model formulas of modeling container that is a child of the time series database.
= FloorI(X1,2)

The X1 factor points are rounded down to the nearest number that is multiple of two.

It can be used in model formulas of modeling container.

See also:

Functions Available in Expression Editor │ Arithmetic FunctionsIModelling.FloorI