The SSRS Floor function is a Mathematical function that returns the largest integer value less than or equal to the given double-precision floating-point number. The syntax of the Floor function to return the nearest integer less than or equal to the floating-point value in a numeric field is as shown below.
=Floor(4.67) - returns 4
=Floor(4.27) - returns 4
To demonstrate the Reporting Services Floor function, we use the Products table below, which has 14 records. The image shows the records in the table report; the result is in an empty column.
SSRS Floor function Example
To do this, right-click the textbox under the Result Header and choose the Expression to open the window below. The Floor function below will return the nearest integer values of the SalesAmount column without considering the decimals.
=Floor(Fields!SalesAmount.Value)
Similarly, let me create one more new column to the right of the Cost and name it Floor Cost. The SSRS Floor function below the expression returns an integer value less than or equal to the floating-point number in the standard cost column.
=Floor(Fields!StandardCost.Value)
Please click the preview tab to see the Floor report.
