User Manual

10.03.2024

MANUAL

Formula (Extended): $ROUNDDOWN Function

## Overview Return the value of a numerical value rounded down to the specified number of digits. ## Syntax ``` $ROUNDDOWN(Numerical value, Number of digits) ``` ## Parameters |Parameter|Type|Required|Description| |:---|:---|:---|:---| |Numerical value|Half-width numerical value|Required|Numerical value to be rounded down. | |Number of digits|Half-width numerical value|Required|Number of digits resulting from truncating a numerical value. | ### Column Usable as Parameters |Parameter|Classification|Numerical Value|Date|Description|Check| |:---|:---|:---|:---|:---|:---| |Numerical value|Yes|Yes|No|Yes|No| |Number of digits|Yes|Yes|No|Yes|No| ## Return Value The numerical 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. If the drop-down list has values, the options that match the values ​​are displayed. | |Numerical 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 ![image](https://pleasanter.org/binaries/af2c895ac2ac42089856d05fadeccb96) ### Parameters ![image](https://pleasanter.org/binaries/4b179bf842db453d9825577da6b11ad8) ### Calculation Result ![image](https://pleasanter.org/binaries/fb9cba75ca324118b133da47d25bc5b5) ## Usage Example 2 Truncate to one decimal place ### Formula ![image](https://pleasanter.org/binaries/c13c77065eb643068968be3d02114c35) ### Parameters ![image](https://pleasanter.org/binaries/0e6398497d274e4d86943ce9dda4fbfe) ### Calculation Result ![image](https://pleasanter.org/binaries/62f88e8cccdf42f6a9e300823172a578)
TOP
このページをシェアする
記載された商品名、各製品名は各社の登録商標または商標です。 © Implem Inc.