Numerical Formatting
Infoveave Data Automation — Numeric
500000 becomes 500,000 and 0.15 becomes 15% — each column formatted in the style that fits its audience without a single formula or cell edit.
Raw numeric data stored in pipelines is optimized for computation, not human reading. A sales figure of 1250000 takes a moment longer to parse than 1,250,000, and a margin ratio of 0.187 communicates less clearly than 18.7% in a board report. Formatting those values correctly for each audience — Western comma separation for US markets, Indian lakh comma format for South Asian reporting, percentage notation for ratio metrics — typically requires formula columns in Excel or presentation-layer transformations that need to be maintained separately for each output format. Numerical Formatting applies these display patterns directly in the data pipeline so every downstream consumer — dashboards, exports, API responses — receives data in the correct format without separate formatting layers.
What Numerical Formatting does
Apply display formatting to numeric columns using comma separators, Indian number format, percentage notation, and auto formatting in Infoveave. Prepare clean numeric outputs for dashboards, Excel exports, and presentation-ready reports without formula maintenance.
When to use Numerical Formatting
- You are preparing a dataset for export to Excel, a PDF report, or a presentation where numeric values need comma separators for readability across columns containing figures like sales totals, headcounts, and expense amounts in millions
- You are delivering a report for an Indian-market audience where financial figures should follow the lakh and crore grouping convention (5,00,000 for five lakh, 1,00,00,000 for one crore) rather than the international three-digit grouping pattern
- You have computed ratio or share columns containing values between 0 and 1 — market share, error rate, gross margin — and need to display them as percentages for a dashboard or presentation without changing the underlying ratio values in the source dataset
- You are cleaning data from multiple source systems where numeric formatting is inconsistent — some sources include symbols, some use dots instead of commas — and need all values standardized to a single display format before loading to a reporting layer
When to avoid it
- You need to change the numerical precision — round a value from 12.345 to 12.35 — rather than change its display grouping pattern; Numerical Formatting changes the display representation but does not apply rounding; use Round Numbers first, then format
- You need to parse formatted numbers back into raw numeric values — removing commas or percent signs so arithmetic can be applied — that operation is the reverse of formatting and requires a custom cleaning step such as Extract Numbers or Find and Replace
- The values are already in the correct display format and just need to be typed as text strings; Numerical Formatting is for applying a new format to raw numeric input, not for passing already-formatted text through unchanged
Where it fits in your Infoveave automation
Numerical Formatting 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 Numerical Formatting
Real scenarios where this transformation saves hours of manual work.
Format Financial Report Columns for Western and Indian Audiences
A finance team exports monthly P&L reports to both US and Indian regional stakeholders. The US report uses Western comma grouping (1,250,000) for revenue and expense columns, while the India report uses Indian lakh grouping (12,50,000). Numerical Formatting is applied twice in parallel pipeline branches — once with Western format for the US export and once with Indian format for the India export — so the same source dataset produces correctly formatted reports for each audience.
Convert Margin Ratios to Percentage Strings for Dashboard Cards
A retail analytics team computes gross margin, pick rate, and return rate as decimal ratios between 0 and 1. The executive dashboard displays these metrics as percentage values on KPI cards. Numerical Formatting converts each ratio column to Percentage format — multiplying by 100 and appending the percent sign — so the dashboard displays 18% instead of 0.18 for gross margin without requiring dashboard-side calculation or formatting logic.
Format Production Volume Figures for Shift Reports
A manufacturing operations team generates shift production reports where output volumes, defect counts, and capacity utilization numbers appear as raw integers and decimals. Numerical Formatting applies comma separators to volume columns and percentage notation to utilization columns so the shift report is immediately readable by plant supervisors without requiring Excel formula layers or manual formatting on the exported file.
See Numerical Formatting in action
Input data (left) is transformed using the configuration below. The output table (right) is ready for dashboards or downstream steps.
##,## (comma-separated Western)Percentage (%)EnabledInput Data
| Region | Sales | Profit |
|---|---|---|
| North | 500000 | 0.15 |
| South | 120000 | 0.20 |
| East | 950000 | 0.05 |
| West | 45000 | 0.12 |
Output Data
| Region | Sales | Profit |
|---|---|---|
| North | 500,000 | 15% |
| South | 120,000 | 20% |
| East | 950,000 | 5% |
| West | 45,000 | 12% |
Configuration
Key fields to configure in the Infoveave workflow builder. Full reference available in the documentation.
Column Map
Select each column to format and assign its display pattern. Auto lets Infoveave determine the best-fit format based on the value range. The hash patterns control grouping — ##,## applies Western three-digit grouping with commas (1,000,000), and ##,##,## applies Indian two-digit sub-grouping after the first three digits (10,00,000). None returns the raw number without any separators. Percentage multiplies the value by 100 and appends a percent sign.
Include Original
Enable to retain source columns alongside formatted output columns. Because formatting converts numeric values to display strings, downstream arithmetic should use the original unformatted numeric columns. Enable this when the formatted output is needed for display while raw values are still needed for calculations in subsequent pipeline steps.
Frequently asked questions
Everything you need to know about Numerical Formatting in Infoveave.
Also in Numeric — and what runs before & after
Transformations in the same family as Numerical Formatting, often chained together in the same Infoveave workflow.
Part of Infoveave Data Automation
80+ transformations. Zero manual steps.
Numerical Formatting 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?
