User Manual

10.03.2024

MANUAL

Formula (Extended): $ROUND function

## Overview Return the value of a numerical value rounded to the specified number of digits. ## Syntax ``` $ROUND(Numerical value, Number of digits) ``` ## Parameters |Parameter|Type|Required|Description| |:---|:---|:---|:---| |Numerical value|Half-width numerical value|Required|Numerical value to be rounded. | |Number of digits|Half-width numerical value|Required|Number of digits after rounding the 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 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/35639f46991340a8abb578a31bceee44) ### Parameters ![image](https://pleasanter.org/binaries/8ded15230d564953bb94a84d196623a1) ### Calculation Result ![image](https://pleasanter.org/binaries/213747d20c0349d182406d8042a582a5) ## Usage Example 2 Round to one decimal place ### Formula ![image](https://pleasanter.org/binaries/0433e7a3074f4f0ba59f4c288890bd78) ### Parameters ![image](https://pleasanter.org/binaries/8ed86bfd19754f3295002c70734f6d6c) ### Calculation Result ![image](https://pleasanter.org/binaries/9024d2f1747c48b598781fb6601afc26)
TOP
このページをシェアする
記載された商品名、各製品名は各社の登録商標または商標です。 © Implem Inc.