Skip to content

Formula (Extended): $ROUNDDOWN Function

Overview

Return the value of a numeric value rounded down to the specified number of digits.

Syntax

$ROUNDDOWN(Numeric value, Number of digits)

Parameters

Parameter Type Required Description
Numeric value Half-width numeric value Required Numeric value to be rounded down.
Number of digits Half-width numeric value Required Number of digits resulting from truncating a numeric value.

Column Usable as Parameters

Parameter Classification Numeric Value Date Description Check
Numeric value Yes Yes No Yes No
Number of digits Yes Yes No Yes No

Return Value

The numeric value is rounded down to the specified number of digits.

Return Value Display Content

Target Display Content of Return Value
Classification (including title, status, manager, owner) Display return value. In the case of a drop-down list with values, the options that match the return value are displayed.
Numeric Value (including work volume, progression rate, remaining work volume) Display return value.
Date (including start and completion) Do not display.
Description (including content) Display return value.
Check (including lock) Do not display.

Usage Example 1

Specify parameters by screen column name (name displayed)

Formula

Formula using the $ROUNDDOWN function in usage example 1

Parameters

Parameters specified in usage example 1 of the $ROUNDDOWN function

Calculation Result

Calculation result of usage example 1 of the $ROUNDDOWN function

Usage Example 2

Truncate to one decimal place

Formula

Formula using the $ROUNDDOWN function in usage example 2

Parameters

Parameters specified in usage example 2 of the $ROUNDDOWN function

Calculation Result

Calculation result of usage example 2 of the $ROUNDDOWN function