MOD (Report Builder 1.0)
Returns the remainder after a number is divided by a divisor. The divisor cannot be 0.
Syntax
MOD(number, divisor)
number |
Indicates the number for which a remainder is to be found. |
divisor |
Specifies the number by which to divide. |
Remarks
- The sign of the remainder is always the same as the sign of the divisor.
Example
Formula |
Result |
|---|---|
MOD(3897, 2) |
The remainder of 3897/2 = 1 |
MOD(1218, -53) |
The remainder of 1218/-53 = -1 |
MOD(-4, -3) |
The remainder of -4/-3 = -1 |