Format numbers

When working with partners and external systems, it’s common to receive data that doesn’t quite match the format you require. The Format numbers step transforms values into whatever custom numeric value you require. 

Building challenge

  • Add a card titled “Format currency values” after our “Format date values” card and drop a Format numbers step on the card.
  • Update the format of the Line Item Price column to include a dollar sign ($) and two decimal places. 

To check your work, take a look at this quick video.

How to use the step

  1. Drag a Format numbers step onto the canvas. 
  2. Select the columns you want to reformat. 
  3. Specify an updated format for the column values. 
  4. Click the three dots next to your format selection to access advanced settings such as number of decimal places, currency symbols, and rounding options. 

Pro tip

  • Unlike traditional spreadsheets that require data types to be specified per column, Parabola handles this automatically.
  • If you ever run into an Invalid Format issue while using an Add math column step (which we’ll go over in the next lesson), use the Format numbers step before the calculation to ensure the data is properly formatted.

Visit our support docs to learn more about the step. 

Next lesson
Freight & Logistics
Retail & Ecomm
Automatically manage your CRM
Automatically update store inventory
Better, faster, more powerful reports
Custom metrics, anywhere
Ecommerce Marketing Flows
Ecommerce Operations Flows
Generate rich customer insights
Go beyond the limitations of spreadsheets
Intelligent search and email marketing
Manage unique products
Powerful, custom reporting
Quickly respond to low inventory
RevOps Use Cases
Set up triggered alerts (even complicated ones)
Support your Sales team
Use APIs without any code