ROUNDUP Function

Numeric field values can be rounded to a specified value before passing to passed to a metric function by using the ROUNDUP function. The general syntax for using the ROUNDUP function is:

metric(ROUNDUP(field,value))

Where:

•	metric is the metric function such as SUM or MAX.

•	field is an integer, long, float, or double scalar field.

•	value is an integer rounding value.

If the rounding value is positive, each field value is rounded up to the nearest multiple of the rounding value. If the rounding value is negative, each field value is rounded down to the nearest multiple of the rounding value. The ROUNDUP function is useful, for example, when using metric expressions where actual field values should be converted to some other, nearest value. For example:

&m=SUM(ROUND(Session.Duration,90)) * 0.03

This metric expression rounds each Session.Duration value to the nearest multiple of 90, sums the rounded values, then multiplies the total by 0.03.