MOD

Returns the remainder after dividing one number by another to support calculations involving intervals or divisibility.

The MOD function divides one number by another and returns the remainder of the division. It is commonly used in calculations involving cyclic patterns, intervals, or determining whether a number is divisible by another number.

Syntax

MOD(dividend, divisor)

Arguments

dividend - number to be divided (Required).

divisor - number you are dividing by (Required).

Example

MOD([AllocatedBudget],[CostCenters])

Use the mod function to calculate the remaining amount after dividing the allocated budget among cost centers, as shown in the example.

Use the MOD function to divide allocated budget among cost centers