round()

Round

Syntax

Function:
  • ROUND(value, x)
Parameters:
  • value =  a numeric value
Outputs:
  • an integer or decimal number
Description:
  • The Round() function will round a ‘value’ down or up to ‘x’ number of decimal places.
Used:
in a Formula BuilderFormula Builder

 

Example
Result
Note
ROUND( 24.6744 , 2) 24.67
ROUND( {{UnitPrice}} , 3) 986.365   {{UnitPrice}} = 986.36587
ROUND( {{UnitPrice}} / 3 , 4) 328.7886