How to Round Decimal Values in Builder

Learn how to round numeric columns in Builder with SQL.

Solution

To round a numeric value or column to a certain number of decimal places, apply a SQL query using PostgreSQL’s round function:

SELECT
  *,
  round(column::numeric, 2) as round_column
FROM
  tablename

This approach converts the column to a numeric type and rounds it to the specified number of decimal places (in this example, 2 decimal places).