floor

floor() function is the Standard function available in 200OK.

Description : The floor function rounds down a decimal to the nearest integer, returning the largest integer value that is less than or equal to the input value.

Syntax : fx_floor()

Example : fx_Floor(39.99) it returns the value as 39.

Here we go with simple scenario using the above function.

Scenario : In a retail store, the manager is pricing items based on their cost. They use the fx_floor function to determine the final selling price by rounding down the calculated price to the nearest whole dollar, ensuring competitive pricing and maximizing sales.

Request Side :

Passing the value inside the function
Passing the value inside the function using index pattern

Response Side :

Last updated