User Manual

10.03.2024

MANUAL

Formula (Extended): $MAX Function

## Overview Find the maximum value of the arguments. ## Syntax ``` $MAX(Num1, [Num2],...) ``` ## Parameters |Parameter|Type|Required|Description| |:---|:---|:---|:---| |Num1|Half-width numerical value|Required|The first numerical value for which the maximum value is to be found. | |[Num2],...|Half-width numerical value|Optional|Additional numerical value for which the maximum value is to be found. | ### Column Usable as Parameters |Parameter|Classification|Numerical Value|Date|Description|Check| |:---|:---|:---|:---|:---|:---| |Num1|Yes|Yes|No|Yes|No| |[Num2]|Yes|Yes|No|Yes|No| ## Return Value The maximum value of the arguments. An error will occur if an error value or a string that cannot be converted to a numerical value is specified as an argument. ### 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 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 parameters by screen column name (name displayed) ### Formula ![image](https://pleasanter.org/binaries/7068ee7c0a0b4d06863710e9a05d90c9) ### Parameters ![image](https://pleasanter.org/binaries/0c9399aedbb14aeaa914c412d8e85395) ### Calculation Result ![image](https://pleasanter.org/binaries/0a51fa9f532a4e3ea1add38a56bdbd79)
TOP
このページをシェアする
記載された商品名、各製品名は各社の登録商標または商標です。 © Implem Inc.