MOD (Report Builder)
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 |
See Also
Concepts
Working with Formulas (Report Builder)
Using Functions (Report Builder)
Math Functions (Report Builder)
Report Builder How-to Topics
Working with Literals in Formulas and Filters (Report Builder)
Formatting Numerical Data (Report Builder)