Overview
FLOOR is a numeric function that returns the largest integer value less than or equal to the given number.
In simpler terms, imagine you're looking at a number line with all the whole numbers (0, 1, 2, 3, and so on). When you use the FLOOR function on a specific number, it points to the largest whole number that is smaller than or equal to that number.
For example, if you think of the number 3.5, the FLOOR function will take you back to 3. Now consider a number like 7.2; the FLOOR function will still return 7, because 7 is the largest whole number that is less than or equal to 7.2.
This function is like ROUND, but it always rounds down to the nearest whole number, making it a handy feature for various calculations and data organization tasks in NetSuite.
Understanding the Syntax
Here, 'number' represents the numerical field or expression you want to round down to the nearest whole number.
For example:
Imagine you're analyzing the sales performance of a particular product in your inventory over a year. You want to calculate the monthly average sales and then round down this average to make conservative estimates for future planning.
Using a Transaction Search, add a Formula (Numeric) field with Summary Type = Maximum:
Formula: FLOOR(SUM({quantity})/12)
If the total quantity of the product sold in one year is 1330, the monthly average sales would be 1330 / 12 = 110.83.
Now, applying the FLOOR function:
FLOOR(110.83) = 110
The result is rounded down to 110, providing a conservative estimate of the monthly sales for this item. This approach ensures that your business plans are based on a slightly lower sales figure, creating a buffer for potential fluctuations or unexpected circumstances.
-----
If you find this information useful, let us know by reacting or commenting on this post!