Round a Column's Values

Rounds the values in a specified column of a table to a given number of decimal digits.

Overview

Rounds the values in a specified column of a table to a given number of decimal digits.

Input Concepts

Concept	Type	Description	Default	Required
table	table	The table containing a column with values to be rounded.	No default	Yes
column	text	The NAME of the column to be rounded, enclosed in quotes.	No default	Yes
decimal digits	int	The number of decimal places to round to.	0	No

Output Concepts

Concept	Description
table	The table with the column values rounded.

Examples

1. Round a Column

Automation

create an integer table
insert a column in the integer table where
  the column name is "Age"
  the column values are 30.6, 25.2, 35.5
  the column number is 4
round the table's "Age" column

Results

Amt	Min	Max	Age
100.0	10.0	300.0	31
200.0	5.0	500.0	25
-	-	-	36