Floor [Floor]

Return to Complete List of Functions

The Floor function returns the first integer that is less than or equal to a given value. For positive numbers, this is also known as "rounding down." See below for a list of similar functions. Parameters ------------------ Value         The value to use in the calculation. This is typically a field in a data series or a calculated value. Function Value ------------------------ The Floor of the number is the first integer that is less than or equal to a given number. This is primarily used for "rounding down" positive numbers to the nearest integer. Data       Floor(Data) --------------------------------   -1.25         -2.00   -1.00         -1.00   -0.75         -1.00   -0.50         -1.00   -0.25         -1.00    0.00          0.00    0.25          0.00    0.50          0.00    0.75          0.00    1.00          1.00    1.25          1.00 Note: This function is based on the C math library definition of the floor function. It differs significantly from the Floor function in Microsoft Excel. Similar Functions --------------------------- Round          Return the closest integer to a value. Ceiling          Return the first integer that is greater than or equal to a value. ("Rounding up.") Floor             Return the first integer that is less than or equal to a value. ("Rounding down.") Integer          Return the integer portion of a value. ("Rounding towards zero.")