User Manual

10.03.2024

MANUAL

Formula (Extended): $VALUE Function

## Overview Convert a string that represents a numerical value into a numeric value. ## Syntax ``` $VALUE(String) ``` ## Parameters |Parameter|Type|Required|Description| |:---|:---|:---|:---| |String|Arbitrary String|Required|| ### Column Usable as Parameters |Parameter|Classification|Numerical Value|Date|Description|Check| |:---|:---|:---|:---|:---|:---| |String|Yes|Yes|No|Yes|No| ## Return Value Half-width numerical value. An error will occur if it cannot be converted into a numerical value. ### 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. | |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/150838a2e2424ea48bd0a7ebd121e5bf) ### Parameters ![image](https://pleasanter.org/binaries/0aea4d02fc4c438e99c56ab8d2c4adca) ### Calculation Result ![image](https://pleasanter.org/binaries/bdf9d4a5d7504c44817ab17ea02cf7b9)
TOP
このページをシェアする
記載された商品名、各製品名は各社の登録商標または商標です。 © Implem Inc.