Skip to content

ROUND

Description

ROUND(number[, precision]) returns the value of the given parameter, rounded to the closest whole number or to the given precision\ \ Note that Atfinity uses bankers rounding also called round half to even, so e.g. 2.5 is rounded to 2, but 3.5 is rounded to 4 (see this wikipedia article about the topic)

Example

p is Person
ROUND(p.total_fee)

This expression returns the total fee that applies to a person, rounded to the whole number. The value for p.total_fee could come from another information field, where an expression with SUM is used to calculate the total fee.

Example with precision

p is Person
ROUND(p.total_fee, 2)

This expression returns the total fee that applies to a person, rounded to two decimal places. This could, for example, be 290.90.