User Manual

10.03.2024

MANUAL

Formula (Extended): $MOD Function

## Overview Return the remainder when dividing a numerical value. ## Syntax ``` $MOD(Numerical value, Divisor) ``` ## Parameters |Parameter|Type|Required|Description| |:---|:---|:---|:---| |Numerical value|Half-width numerical value|Required|Numerator of division. | |Divisor|Half-width numerical value|Required|Denominator of division. An error occurs if 0 is specified. | ### Column Usable as Parameters |Parameter|Classification|Numerical Value|Date|Description|Check| |:---|:---|:---|:---|:---|:---| |Numerical value|Yes|Yes|No|Yes|Yes| |Divisor|Yes|Yes|No|Yes|No| ## Return Value The remainder is when dividing a numerical value by a divisor. The return value has the same sign as the divisor. ### 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 parameters by screen column name (name displayed) ### Formula ![image](https://pleasanter.org/binaries/a4cae134b4ef4898a4f7ebd14a85d8c9) ### Parameters ![image](https://pleasanter.org/binaries/6ec9f6113ca54399b2bcaf10abd722f7) ### Calculation Result ![image](https://pleasanter.org/binaries/a675b94675c74fbc81777e7c321bcd73)
TOP
このページをシェアする
記載された商品名、各製品名は各社の登録商標または商標です。 © Implem Inc.