ROUND() Function

Round a value or indicator to a specified number of decimal places


🗒️ Description

The ROUND() function is used to control the number of decimal places in a numerical result, making values more readable, especially in financial models where too many decimal points can clutter dashboards and reports.


You can apply ROUND() to:

  • A constant value
  • A formula expression
  • Another indicator’s values

This is useful when you want results to match typical rounding expectations (e.g. for pricing, unit values, or KPIs), and when presenting calculations where excessive precision is unnecessary.

✏️ Syntax & Variables

1 round(value, decimal_places)
  • value: A number, a formula, or a reference to another indicator
  • decimal_places: Number of decimal places to round to (must be a whole number)

âś… Expected result & examples

Let’s say you want to calculate how many customers were lost each month based on a churn rate applied to the opening number of customers. The result will be a decimal (like 2.57), but in real life, you can’t lose 0.57 of a customer—so you want to round that result to the nearest whole number.

In this example:

  • In March, the number of opening customers is 61
  • The churn rate is 3.2%
  • The raw result = 61 Ă— 0.032 = 1.95

By using the ROUND function with 0 decimal places, the value becomes 2.


This allows you to accurately report that 2 customers were lost in March, rather than displaying a confusing decimal.