MOD(m, n)

 

Returns the remainder of m divided by n.

Examples:

MOD(5, 2)

Returns 1.

MOD(10, 5)

Returns 0.

MOD(YEAR( ),4)

Returns 0 if the year is an election year (i.e., divisible by 4 with no remainder).

Other Resources

• Expression Examples
• Filtering Records
• Knowledge Base Article R11493 - All About Expressions
• Knowledge Base Article R11515 - Filter Expression Examples
• Knowledge Base Article R11487 - Working with Indexes, Filters, and QuickViews
• Knowledge Base Article R10750 - Report Writer, Filter, and WorkFlow Functions (provides link to downloadable .pdf)