Rounds a numeric input field to the nearest integer, with an optional method to set the rounding type.

ParameterTypeRequiredDefault ValueDescription
asstringoptional[a]Same name as input field The output name of the field to round.
field[b]stringrequired  The names of the field to round.
howstringoptional[a]round Method used to round the number.
   Valid Values
   ceilRound up to the nearest whole number
   floorRound down to the nearest whole number
   roundStandard rules; for example, <0.5 rounds down, >0.5 rounds up

[a] Optional parameters use their default value unless explicitly set.

[b] The parameter name field can be omitted.

Hide omitted argument names for this function

Show omitted argument names for this function

round() Examples

Click + next to an example below to get the full details.

Basic Rounding

Rounding Within a Timechart

Rounding to n Decimal Places