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.