MOD

The MOD function divides two numbers and returns the remainder.

Syntax

mod(dividend, divisor)

Arguments

dividend - number to be divided

divisor - number you are dividing by

Example

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

MOD([AllocatedBudget],[CostCenters])

Use the MOD function to divide allocated budget among cost centers