ROUNDDOWN Function

Description

Round down a number to the number with the specified number of digits.

Specify the original value in the first argument and the number of digits in the second argument.

If the number of digits is zero, the first decimal place is rounded down to the nearest integer. If the number is positive (N), the (N+1)th decimal place is rounded down to the nearest integer, and if the number is negative (-N), the Nth decimal place is rounded down to the nearest integer. The number of digits can be omitted; if it is omitted, it is the same as zero.

Usage Examples

${rounddown(Number_1, 2)}

Example results according to the value of the Number_1 field
    Number_1 = 1.234 → 1.23
    Number_1 = 1.235 → 1.23
${rounddown(Number_1, -2)}

Example results according to the value of the Number_1 field
    Number_1 = 1234 -> 1200
    Number_1 = 1254 -> 1200

The example below rounds down x to the nearest whole number.

= rounddown(x)

Precautions

When the original value is negative, rounding down results in a lower absolute value. This behaviour differs from the “[Round Down Fields]"(../../actions/field/floor_field) feature.

For example:

  • rounddown(-1.23, 0) results in -1
  • The result of rounding down -1.23 using the “Round Down Fields” method is -2.