Round / Manipulation Layer

Round floating-point numbers to specified decimal places. Similar to pandas' round() or R's round().

Mathematical behavior:

  • Values > 0.5 round up (3.7 → 4.0)
  • Values < 0.5 round down (3.2 → 3.0)
  • 0.5 rounds to nearest even (3.5 → 4.0, 2.5 → 2.0)

Common applications:

  • Financial calculations (2 decimals)
  • Percentage representations (1 decimal)
  • Measurement standardization
  • Report formatting
  • Display normalization
  • Data summarization
  • Statistical rounding
  • Precision control

Example: With decimals=2, 3.14159 → 3.14, 2.719 → 2.72

Table
0
0
Table

Select

column

Floating-point column to round. Common scenarios:

  • Calculated ratios needing standardization
  • Raw measurements requiring formatting
  • Computed metrics for reporting
  • Precise values for display
  • Decimal numbers for alignment

Number of decimal places to retain. Common settings:

  • 0: Whole numbers (3.7 → 4)
  • 1: Tenths (3.78 → 3.8)
  • 2: Cents/percentages (3.789 → 3.79)
  • 3: Milliseconds (3.7891 → 3.789)
  • 4: High precision (3.78912 → 3.7891)

Name for the new column. If not provided, the system generates a unique name. If AsColumn matches an existing column, the existing column is replaced. The name should follow valid column naming conventions.