User Manual

10.03.2024

MANUAL

Formula (Extended): $TRUNC Function

## Overview Return the value with the decimal part of the numerical value truncated to the specified number of digits. ## Syntax ``` $TRUNC(Numerical value, [Number of digits]) ``` ## Parameter |Parameter|Type|Required|Description| |:---|:---|:---|:---| |Numerical value|Half-width numerical value|Required|Numerical value to truncate the decimal part. | |[Number of digits]|Half-width numerical value|Optional|Specify the number of digits after truncation. If omitted, 0 is assumed. | ### 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 A numerical value with the decimal point truncated 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 ① Specify the parameter by the screen column name (name displayed) ### Formula ![image](https://pleasanter.org/binaries/26865254b09b4e32933d488dd13f8a76) ### Parameters ![image](https://pleasanter.org/binaries/e8174857a6654bb5abe47e9297f2c7c9) ### Calculation Result ![image](https://pleasanter.org/binaries/b6f49f954ef042a6ae873650d1da75c6) ## Usage Example ② Specify the parameter [Number of digits] ### Formula ![image](https://pleasanter.org/binaries/c6c3ac947b8942deb3fdc3512e6d4bc1) ### Parameters ![image](https://pleasanter.org/binaries/f34e0fb7ad2945f7bc8c48b79ceeca4e) ### Calculation Result ![image](https://pleasanter.org/binaries/450899c3d21045a58199dd88689cd22b)
TOP
このページをシェアする
記載された商品名、各製品名は各社の登録商標または商標です。 © Implem Inc.