Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.anlytic.com/llms.txt

Use this file to discover all available pages before exploring further.

Rounds the number down to the closest multiple of the specified number Category: math Syntax: 
MRound([number], multiple)
Returns: Number Context Filtering: ✓ Yes

​
Parameters

NameTypeRequiredDescription
numbernumber or column✓ YesThe number to be rounded
multiplenumber✗ NoThe multiple to round the number to
Allowed Column Types for number: INT, FLOAT, DECIMAL

​
Validation

  • Minimum parameters: 1
  • Maximum parameters: 2

​
Examples

MRound([Number])
Rounds the Number column by a factor of 1 because no argument is passed. This is equivalent to the result of the factor of (-1). 
MRound([Cost], 5)
Rounds each value in the Cost column to the nearest multiple of 5 
MRound(23, 5)
Returns 25 Result: 25 
MRound(27, 5)
Returns 25 Result: 25 
MRound(23, -5)
Returns 25 (negative factor sign is ignored) Result: 25
Last modified on March 13, 2026