POWER

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] )