ROUND
Rounds the values in a numeric field. A Precision Value of 1 will round as normal. A Precision Value -1 will round to the nearest 10. eg 36.75 would round to 40, 34.25 would round to 30.
ROUND ( <field_name or value> [, <precision_value = 0>] )
-
field_name or value: The numeric field or value to perform the calculation on.
-
precision value: Default is 0.
Example: create a field at the SALES level that rounds the value of each purchase
ROUND ( [SALES.PRODUCT VALUE] )