FLOOR function

This topic describes the formula syntax and usage of the FLOOR function in the Data Quality Execute Formula transform.

Description

Rounds a number down, toward zero.

Syntax

FLOOR(number,significance)

The FLOOR function syntax has the following arguments:

  • number Required. The numeric value you want to round.
  • significance Required. The multiple to which you want to round.

Notes

  • If either argument is nonnumeric, FLOOR returns an error.
  • If number is positive and significance is negative, FLOOR returns an error.
  • If the sign of number is positive, a value is rounded down and adjusted toward zero. If the sign of number is negative, a value is rounded down and adjusted away from zero. If number is an exact multiple of significance, no rounding occurs.

Example

Table 1. Data
Number1 Number2 Number3 Number4 Number5
3.7 -2.5 2.5 1.58 0.234
Table 2. Formulas
Formula Description Result
FLOOR([Number1],2) Rounds 3.7 down to nearest multiple of 2. 2
FLOOR([Number2],-2) Rounds -2.5 down to nearest multiple of -2. -2
FLOOR([Number3],-2) Returns an error, because 2.5 and -2 have different signs.
FLOOR([Number4],0.1) Rounds 1.58 down to the nearest multiple of 0.1. 1.5
FLOOR([Number5],0.01) Rounds 0.234 down to the nearest multiple of 0.01. 0.23