Round Numbers
Infoveave Data Automation — Numeric
Prices rounded to two decimal places, discount percentages floored to whole numbers, and scores ceiled for tier assignments — all configured in one step without touching a formula cell.
Floating-point arithmetic leaves raw numeric columns with 8 or 12 decimal places that are never appropriate for reporting, display, or downstream comparison. A pricing dataset where unit prices are stored as 12.345000000001 will not match correctly against a lookup table that stores 12.35, and a dashboard displaying 5.9999999823 as a discount percentage is harder to read than 6. Round Numbers applies three precisely controlled rounding methods — standard mathematical rounding, ceiling to the nearest upper value, and floor to the nearest lower value — with configurable decimal precision per column. The result is numeric data that is consistent, predictable, and ready for presentation, aggregation, and comparison without manual cell-by-cell editing or formula maintenance.
What Round Numbers does
Round numeric column values using Round, Ceil, or Floor methods with configurable decimal precision in Infoveave. Prepare clean financial figures, scores, and price columns for reporting, comparison, and export without manual cell editing.
When to use Round Numbers
- You have a pricing or financial dataset where raw calculated amounts contain excessive decimal places and need to be presented at two decimal places for invoices, reports, or dashboards without changing the underlying arithmetic that produced the values
- You are computing percentage metrics — discount rates, margin percentages, fill rates — and need to floor or ceil the result to whole-number integers for use in tier classification rules, threshold comparisons, or dashboard KPI cards
- You are preparing data for export to a system that cannot accept values with more than a specified number of decimal places, and need to round all affected columns to the correct precision before the export step in the pipeline
- You are normalizing scores, ratings, or aggregate metrics that are generated with variable precision and need to be standardized to a consistent decimal format before downstream comparison, ranking, or segmentation
When to avoid it
- You need to convert raw numbers into formatted strings with comma separators or currency symbols for display — rounding changes the value's precision but does not change its display format; use Numerical Formatting for that
- You need to clamp values within a minimum or maximum range rather than change their decimal form — for out-of-bounds enforcement use Force Numerical Range instead of rounding
- Your column contains text-formatted numbers that need cleaning before numeric operations can be applied — use Extract Numbers to strip non-numeric characters first, then apply rounding in a subsequent step
Where it fits in your Infoveave automation
Round Numbers is one step inside a multi-step Infoveave workflow. Chain it with other activities — no code, no manual hand-offs.
Build this workflow visually in Infoveave Data Automation — drag, connect, and schedule with no infrastructure setup.
How teams use Round Numbers
Real scenarios where this transformation saves hours of manual work.
Round Price and Discount Columns for Clean Invoice Export
A retail operations team generates invoice datasets where unit prices are computed from cost-plus formulas that produce values like 12.3450001 and discount percentages like 0.14999998. Round Numbers is configured to apply Round at precision 2 to the price column and Floor at precision 0 to the discount column. The resulting dataset has clean, presentable figures for invoice generation and matches the format expected by the billing system.
Standardize Calculated Financial Ratios to Two Decimal Places
A finance team computes profitability ratios, margin percentages, and return-on-investment figures that result in values with 10 or more decimal places due to floating-point arithmetic. Round Numbers applies standard Round at precision 2 to all ratio columns, producing outputs like 18.47 instead of 18.473920194. The cleaned dataset is used in monthly financial summary reports and board presentation decks.
Ceil OEE Percentages for Tier Assignment Rules
A manufacturing analytics team computes OEE percentages per production line per shift. Values like 84.12 need to be assigned to the 85+ performance tier rather than the 80-84 tier to match the plant's rounding-up convention. Round Numbers applies Ceil at precision 0 to the OEE column so all values are rounded up to the nearest integer before tier comparison rules run, ensuring the performance tier assignments match the plant operations standard.
See Round Numbers in action
Input data (left) is transformed using the configuration below. The output table (right) is ready for dashboards or downstream steps.
Price — Round at precision 2Discount — Floor at precision 0EnabledInput Data
| Product | Price | Discount |
|---|---|---|
| Laptop | 12.345 | 5.9 |
| Phone | 99.999 | 10.2 |
| Tablet | 45.678 | 8.5 |
Output Data
| Product | Price | Discount |
|---|---|---|
| Laptop | 12.35 | 5 |
| Phone | 100.00 | 10 |
| Tablet | 45.68 | 8 |
Configuration
Key fields to configure in the Infoveave workflow builder. Full reference available in the documentation.
Column Map
Define one or more column transformation rules. Each rule specifies the column to transform, the rounding method, and the decimal precision. Round applies standard half-up rounding — values exactly at the halfway point round away from zero. Ceil rounds up to the nearest value at the configured precision — useful for tier assignments and conservative scoring. Floor rounds down to the nearest value — useful for applying conservative discounts, consumption billing, and capacity planning.
Include Original
Enable to keep the source columns in the output alongside the rounded versions. This is useful for audit trails, before/after comparisons, and pipelines where the original precision values are needed for downstream calculations while the rounded values are used for reporting. When disabled, only the rounded columns are passed to the next step.
Frequently asked questions
Everything you need to know about Round Numbers in Infoveave.
Also in Numeric — and what runs before & after
Transformations in the same family as Round Numbers, often chained together in the same Infoveave workflow.
Part of Infoveave Data Automation
80+ transformations. Zero manual steps.
Round Numbers is one of over 80 transformation activities available inside Infoveave workflows. Chain transformations together — no code, no exports, no waiting for IT.
Ready to see Infoveave in action?
