## MOD function for IBM Planning Analytics (TM1)

MOD returns the remainder after a number is divided by a divisor.

In the video, MOD will be used to calculate the remainder and apply it to the rule to populate the amount measure in the Product Scorecard cube.

## Where can the MOD function be used?

Rules and TurboIntegrator

## Which TM1 Server version is the MOD function available for?

Version 11 and 12

## What is the syntax for MOD?

MOD(number, divisor)

- Number = The number for which we want to find the remainder.
- Divisor = The number by which the argument is divided.

## Relevant Functions

- ABS = Converts a number into an absolute value.
- ASIN = Returns the angle, in radians, whose sine is x.
- ATAN = Returns the angle, in radians, whose tangent is x.
- COS = Returns the cosine of an angle expressed in radians.
- EXP = Returns the natural anti-log of a number.
- INT = Returns the largest value that is less than or equal to a specified value.
- ISUND = Returns 1 if the argument value is undefined.
- LN = Converts a number into an absolute value. Returns the natural base e logarithm of a number.
- LOG = Returns the base 10 logarithm of a positive number.
- MAX = Returns the largest number between two numbers.
- MIN = Returns the smallest number between two numbers.
- MOD = Returns the remainder after a number is divided by a divisor.
- RAND = Function generates a random number.
- ROUND = Function rounds a number to the nearest integer.
- ROUNDP = Rounds a number at a specified decimal precision.
- SIGN = Determines if the number is positive or negative.ACOS = Returns the angle, in radians, whose cosine is x.
- SIN = Returns the sine of an angle expressed in radians.
- SQRT = Returns the square root of a given value.
- TAN = Returns the tangent of an angle expressed in radians.