ROUND
ROUND
returns the value of the given parameter, rounded to the closest whole number.
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)
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.Last modified 6mo ago